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...
The BDR and pglogical apt repository GnuPG signing keys have been renewed. Users should re-import the existing keys. You can verify that it’s still the same key as referenced in...
I have just committed a series of patches that provide support for enum types in the btree_gin and btree_gist standard extensions. This is something I first started work on about...
My colleague Álvaro Herrera gave a terrific explanation of the new XMLTABLE feature from Pavel Stěhule that he’s put a huge amount of effort into, and finally recently committed. I...
