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!
Category Archives: People
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.
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!).
I have just one thing to say – it was a great meetup! I was worried, that the even was scheduled not for the best day: it’s the end of July, when people are either heading to vacation, or at least just trying to spend as much time outdoors, as possible. Besides, for some reason nobody likes to meet on Thursdays.
In spite all of the above – the attendance was great, and the audience was really engaged. Do I need to mention that Bruce is the greatest speaker in the Postgres world?!
The presentation was brilliant, over an hour just passed by, and nobody even asked whether we can have a break 🙂
And now I really hope this won’t be the last time Bruce is visiting Chicago and talking at PUG!
Last week I had to work a lot! I mean, A LOT! But work-wise that was one of the happiest weeks, and I wanted to share with everybody why it felt so happy.
Those of you who worked with me before know, that my favorite activity is working with applications, because optimizing for applications is way more difficult and way more fun than optimizing reports. Yes, you can impress everybody, including yourself, reducing the report run time from one hour to one minute. But how much cooler is it to reduce the page load time from 30 sec to 0.1 sec?! Especially when you have a power not only to write the best queries ever, but also to design the data model “the right way”.
When you do the application database work, the most critical part is to work in close contact with the application developers. And depending on what kind of team you are lucky or unlucky to have, it may be the best or the worst part of your professional experience.
My IT team here in Braviant is one of the best I ever worked with, which was proved one more time last week. The most difficult part has always been connecting the db work and the app work, like: I’ve selected all this data for you, can you read it from the output I am providing? Or: we can give you all input parameters that way, can you process them? Our app developers have already made a huge step “in my direction” agreeing not to use ORM, but to read the output of the database function. Next step – we hit the wall exactly where I expected. I’ve spent a half of Saturday writing my code, so that the app developers could start using in Monday morning… and now they are saying they can’t process correctly the embedded record sets! I’ve heard that many times before, and each time in a couple of hours I would hear: Hettie, there is no way! Let’s do it “the old way”, we know how… That time, however my team kept trying to find a solution, and watching these efforts made me to start thinking how I can change the output on my side. After several iterations going back and forward, we came up with a pretty neat way to return the records, which could be used right away, and even a better approach, which, however would require more work from me, and could not be done on the spot.
And you know – I totally understand, when people hate rewriting one piece of code multiple times, which makes me appreciate even more the willingness to rewrite later, when I will come up with the more automated solution from my side…
I have already written a lot in this post, and I am not sure whether it all make sense, but let me try to summarize. I loved that everybody were willing to compromise, to make adjustments, that there were no “just because” statements, that the whole team was focused on the goal to build the application right from the very beginning, so that we won’t need to worry about performance six months down the road.
Hope it will continue that way. Except of me working on Saturdays part 🙂
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!
Yesterday was a Day – a day when Joe Conway presented at Chicago PUG. He was talking about the PL/R extension of Postgres, which is really important for out data analysts.
We had a full house:
And everybody were listening to the great presentation: