Every major PostgreSQL upgrade I have done on a single primary came with the same conversation: how long can the application be down? is fast, but it is still an outage, and you still have to rebuild or resync the standbys afterwards.A…
On 12 October, the PostgreSQL User Group Vienna met, organized by * Cornelia Biacsics * Ranjeet Kumar Speakers: Mayur B. Radim Marek On 13 October, the San Francisco Bay Area PostgreSQL Meetup Group met online. Christophe Pettus delivered…
PostgreSQL 15's `recursive_worktable_factor` helps you fix slow recursive CTEs by tuning a single estimate. (I consult on PostgreSQL through PGX Inc..)
Yesterday, I spoke about pg_acm at PGConf.EU. Speaking at the biggest Postgres conference in the world is an honor in itself, and it’s not that I have a chance to present there every year, so I am incredibly thankful to the CfP committee…