In the defense of sar (and how to configure it)

Let me discuss a topic that is not inherently PostgreSQL specific, but that I regularly run into while investigating issues on customer systems, evaluating “supportability” of those systems, etc. It’s...
April 26, 2017

BuildFarm client release 4.19

I have released version 4.19 of the PostgreSQL Buildfarm client. It can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-4_19.tgz Apart from some minor bug fixes, the following changes are made: Include the script’s...
April 19, 2017

When autovacuum does not vacuum

A few weeks ago I explained basics of autovacuum tuning. At the end of that post I promised to look into problems with vacuuming soon. Well, it took a bit...
April 19, 2017

Traceable commit for PostgreSQL 10

PostgreSQL 10 now supports finding out the status of a recent transaction for recovery after network connection loss or crash. Recovery from indeterminate COMMIT If there was a COMMIT “in...
April 05, 2017

2ndQuadrant - Not the Gartner Magic Quadrant

It’s still appropriate though. Because that is what we are – thought leaders in open source PostgreSQL. But that’s not what I am here to talk about. The name “2ndQuadrant”...
April 03, 2017

PgDay Paris 2017

Great conference! Paris is a great venue for travellers across Europe and worldwide. PgDay Paris 2017 was held in English and attracted a wide audience from many other countries: UK...
March 24, 2017

How do I re-sign a debian package (deb)?

Are you looking for a rpmsign --resign equivalent for Debian packages? Have you looked at debsign and wondered why you can’t run it on a .deb? Did you try to...
March 24, 2017

PGConf India 2017 - An Event to Remember

Yet another edition of PGConf India came to conclusion in early March. You may have noticed the change from PGDay to PGConf, which signals a much larger gathering of PostgreSQL...
March 24, 2017