AMD, Intel, and PostgreSQL

A few weeks ago I presented an updated 2010 version of my talk on database hardware benchmarking at PG East. CPU and memory performance are particularly important for a PostgreSQL...
April 14, 2010

Trade-offs in Hot Standby Deployments

The new Hot Standby feature in the upcoming PostgreSQL 9.0 allows running queries against standby nodes that previously did nothing but execute a recovery process. Two common expectations I’ve heard...
February 24, 2010

Measuring PostgreSQL Checkpoint Statistics

Checkpoints can be a major drag on write-heavy PostgreSQL installations. The first step toward identifying issues in this area is to monitor how often they happen, which just got an...
January 29, 2010

Sitting on the Dock of the Bay

Just got back from some days away with my family, often sitting on a beach with pen and paper, thinking. Sometimes with my laptop in the shade. Current news is...
August 28, 2009