Bringing together some of the world's top PostgreSQL experts.
One of the more useful bits of PostgreSQL documentation I ever worked on is Tuning Your PostgreSQL Server. When that was written in the summer of 2008, a few months after the release of PostgreSQL 8.3, it was hard to find any similar guide that was both (relatively) concise and current. Since then, myself and […]
For a long time, adding packages to RedHat derived Linux systems has been called “RPM Hell”, for good reason. Particularly before the yum utility came about to help, getting RPM to do the right thing has often been a troublesome task. I was reminded of this again today, while trying to compile a PostgreSQL extension […]
I maintain a number of project whose purpose in life is to make testing portions of PostgreSQL easier. All of these got a decent upgrade over this last week. stream-scaling tests how memory speed increases on servers as more cores are brought into play. It’s fascinating data, enough of it there to start seeing some […]
As the PostgreSQL Elephant continues its march toward yet another release, I’ve been thinking quite a bit about the role users of software should have in its user interface design. Today I proposed something that makes a database parameter people used to have to worry about, and that wasn’t obvious at all how to set, […]
When PostgreSQL 9.0 shipped a few months ago, it included several new replication features. It’s obvious that you can use these features to build clusters of servers for both high availability and read query scaling purposes. What hasn’t been so obvious is how to manage that cluster easily. Getting a number of nodes installed and […]
PostgreSQL development is now done with periodic pauses to review and commit patches that have been submitted, called Commit Fests. The patches themselves are stored on a custom web app, and documentation about the process is on the PostgreSQL wiki. I’m returning to the role of CommitFest manager for this one, which means I get […]
My tour this week of the PostgreSQL West conference has taught me that you can deliver three talks in two days, or you can have fun seeing other people’s talks, but it’s rather difficult to do both. You can also find the slides from Hannu’s talk on Django/Python database calls, which unfortunately he was too ill […]
Since I’ve already pushed my book here once on my blog this week, this version will be short and include two chunks of free (as in beer) content for you. My book covering PostgreSQL performance, from versions 8.1 to 9.0, is now available. Downloads of the 468 page e-book text are available immediately from Packt […]
If you’re looking for a heavy dose of information about PostgreSQL performance tuning, you’re going to find the next month very interesting. We at 2ndQuadrant have been working on two books about PostgreSQL 9.0 this year. You can pre-order those right now, and as I’m staring at a home printed copy of my PostgreSQL 9.0 […]
Whether or not you made it our CHAR(10) conference last month, you can now relive part of the experience by downloading the conference slides. Some of those were posted live during the conference, some showed up later, but almost everything is there now. Sadly, Nic Ferrier’s entertaining presentation about how WooMe (acquired by Zoosk) was scaled […]
