Category Archives: talks

The PG Open videos

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!

Advertisements

Leave a comment

Filed under People, talks

One more reminder about the conference on November 9

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!

Leave a comment

Filed under events, talks

My presentation at PG Open 2017

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:

 My Presentation at PG Open 2017c

Leave a comment

Filed under publications and discussions, talks

Bruce Momjan’s talk at PG Open will be replayed in Chicago – stay tuned!

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.

Leave a comment

Filed under news, People, talks

About PG Open 2017

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!).

The opening:

Continue reading

Leave a comment

Filed under events, news, People, talks

Last Day to submit your talk proposals!

Hey fellow Postgres enthusiasts, especially a Chicago bunch! A friendly reminder, that today is a deadline for the 2Q PGCONF talks submission. If you didn’t submit anything, there is still time, just 1-2 paragraphs highlighting the main idea of  the talk  will be sufficient. Let’s show that Chicago CAN!

Leave a comment

Filed under events, talks

Please join us this Thursday for a very special meetup!

Attention Chicago Postgres users, developers, DBAs and everybody who knows what the word “Postgres” means! In the unlikely event you did not hear about it already – this day is coming! Bruce Momjian will be our guest at the July meeting of the Chicago PostgreSQL User Group, and I do not think I need to say anything else! We are just excited that this is finally happening!

Please RSVP, if you are planning to come, and didn’t RSVP yet – we have a new person at the building reception, and I need to give her a guest list! Also, just for this meetup we will extend the time till 9 PM, so that everybody could enjoy the conversation.

Hope to see you there!

Leave a comment

Filed under events, People, talks