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...
…and why I’m glad I did. It’s not all technical… Who knew?! Last year, Pycon7 was held right about the time I joined 2ndQuadrant. Seeing as I was new to...
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...
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...
Support for using the TAP protocol to run extended regression tests was added to PostgreSQL back in 9.4 with the adoption of Perl’s prove tool and Test::More to test initdb...
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...
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”...
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...
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...
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...