Actually, all the videos from the conference are now available online, which is great. But for those, who are as lazy as me :), I am posting here both my and Chad’s presentations – enjoy!
Just wanted to make sure one more time, that all my friends in Chicago remember about the 2Q PG Conf, which will take place in Chicago on November 9.
I’ve already mentioned earlier, that I will be presenting at this conference, but now the whole schedule is published, and you can see, that all the speakers are just extraordinary!
Hope you can attend!
About a week ago this article from Atlantic landed in my Inbox from one of many newsletters.
And now, returning home from just three days of working remotely, I think about how I agree with many of the points this article makes.
In general I am very thankful, that I have an option of working remotely periodically, but only because otherwise I will have to skip work entirely each time I travel.
I’ve always been a great proponent of remote work, arguing that it can be as efficient, as working in the office if not more, using my work with NY Department of Education as an example. But I have to agree with this article: times have changed. And now I have no doubts, that working remotely for me in my current position should be very limited – both to my own benefit and the benefits of the projects I am working on (which, to be honest, is almost the same thing :))
I was waiting for the videos to be uploaded, but since I am not sure when this is going to happen I figured out I will at least post my presentation. If you compare it with the one I’ve presented at PG Open 2016, you’ll see lots of improvements.
Here is it:
Once again, I did’t write more about PG Open, although I had grand plans. But there were so many interesting talks, that I am still going to write about them, even though it’s already 3 weeks past the conference.
One talk I really enjoyed, was Bruce Momjian “The Window Magic“. You can find the presentation here.
That’s what I really liked about it. Window functions are hard. Seriously. This is one of those things, where you know there are options and answers to everything, but figuring out how to do this takes so long that you almost do not want to do this. What I absolutely love about this presentation is the fact, that it starts from the very basic example, and then adds one feature after another, and each time it is one easy – and logical! – step. And the amazing thing is, that Bruce manages to make sense out of literally each and single option, and they all make sense! None of them looks artificial or “why anybody would want to do that?”
Granted, it won’t be me, if I won’t have any comments :). The comment I had here was, that people should be warned that the window functions are resource consuming. The moment you really figure out this magic, you want to use it everywhere, even instead of min/max with group by! And the execution time will be very different in this case.
And now the best part – Bruce graciously suggested to bring his talk right here to Chicago! Thereby we are moving the November PUG date – it is now scheduled for November 8. Please RSVP to this event here.
Attention fellow chicagoans! Do you want to learn more about PG Open 2017 straight from the participants? Come to Chicago PUG meetup on September 12!
Here is a https://www.meetup.com/Chicago-PostgreSQL-User-Group/events/242081721/link to the meetup – please RSVP there.
Usually I start to write about any conference I am attending while still at the conference. But this time around I had such a busy time, there were so many things going on, that I didn’t… and even now, two days after the conference, I am not sure where to start 🙂
Overall the conference was great. The weather in San Francisco was beautiful, the hotel was great except of the usual “too-much-air-conditioning” .
This time I didn’t sign up for any of the tutorials. so the day I came, I just met several people (which is always the goal at a conference in any case), and we also had the speakers dinner (a very nice one!).