PostgreSQL Conference East 2009, Day Three

As I said yesterday, I was only able to attend a couple of talks at the PostgreSQL Conference East 2009 this morning before leaving to catch my flight back to Virginia.

  • Effects of Flash and SSDs on PostgreSQL – by Jignesh Shah of Sun Microsystems. Jignesh went through a series of comparisons between hard drives and SSD drives, looking at where they really make sense in terms of performance, capacity and price. He found exactly the same things that Vadim wrote about on our blog: write caching is enabled by default, and the vendors don’t want you to disable it, because the device needs the write cache for wear leveling. While SSD has some performance advantages over spindle-based drives, I’m still not seeing it as a killer – yet. But I think these issues will work themselves out. The manufacturers just need to battery back that cache and everything will change.
  • Predicting Postgres Performance: Practical Queueing Theory for Postgres DBAs – by Jonah Harris of myYearbook. Another excellent talk. Basically “queueing theory in a nutshell,” with some examples of how you can expect performance to change, given some things you already know. Someone urged me to get the myYearbook crew to the Percona Performance Conference, and I think we tried but lost the momentum somewhere. I’ll be emailing Jonah about it now. This talk would be perfect there.

Off topic: I picked up a handful of OpenSolaris disks. They’ll send you one free, but if you’re like me, typing in your address is too much to do. I’ll throw it on VirtualBox and see how it does, I’ve been curious about it for a while. If you’re local to me and you want one, let me know and I’ll give you one next time I see you.

And then, sadly, I had to head out the door and get on the train. Goodbye Philly! Goodbye Postgres friends! See you next time.

I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and lots of open-source software for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB. More about me.