Tuning Linux for low PostgreSQL latency

One of the ugly parts of Linux with PostgreSQL is that the OS will happily cache up to around 5% of memory before getting aggressive about writing it out.  I’ve just updated a long list of pgbench runs showing how badly that can turn out, even on a server with a modest 16GB of RAM.  […]

Reducing the postgresql.conf, parameter at a time

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 […]

How not to build PostgreSQL 9.0 extensions on RPM platforms

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 […]

Updates to PostgreSQL testing tools with benchmark archive

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 […]

Telling Your Users to Go Fork Themselves

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, […]

Easier PostgreSQL 9.0 clusters with repmgr

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 […]

pgChess code published

I have been lucky enough to be invited at the marvellous PGDay.eu 2012 conference in Stuttgart, which ended just yesterday. The topic of the first of my two talks has been a collection of PostgreSQL objects that play chess, either between themselves or against a human.

Australia: Last seats for our PostgreSQL courses in Melbourne

2ndQuadrant will be delivering two courses on PostgreSQL in Australia. The location will be the prestigious Rialto Towers, one of the greatest attractions in Melbourne, right in the heart of the Central Business District, and one of the tallest office buildings in the world.

PostgreSQL CommitFest #3 for 9.1 needs you!

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 […]