I just got back from my first European PostgreSQL conference since 2009.  If you missed it, you should be sorry you did.  Me, I mostly went...

Continued from Part 1 . vacuum_freeze_min_age The vacuum_freeze_min_age setting determines the youngest XID which will be changed to F...

Tonight Jignesh Shah of VMware will be presenting on running the DVDStore benchmark with PostgreSQL at SFPUG.  As always, you can catch it l...

A few of our clients run on the Joyent cloud.  Uniquely, Joyent runs SmartOS, an Illumos (i.e. OpenSolaris) distribution, which is the def...

Here's a common situation for PostgreSQL binary replication setups with multiple replicas: the master is down, and you want to promote t...

Given that it's currently around 50F, damp and foggy in San Francisco (so much for Indian Summer), my thoughts turn to freezing.   Speci...

And ... we're off!  PostgreSQL 9.2.0 is finally out , and you can now deploy it for production applications.  So lemme talk a little abo...