Sammlung von Newsfeeds
Christophe Pettus: The Shadow Knows
Dimitri Fontaine: Ten years of Postgres logical replication
A long time ago I ran a write-heavy system on a hub and a handful of workers. Each worker took a share of the application traffic and wrote events locally. The hub owned the reference data (customers, plans, prices), pushed it down to the workers, and pulled every worker’s events back up to compute the invoices. The plumbing was Londiste and PgQ: triggers on every table, a queue per node, a ticker, and a Python daemon per hop. It worked, and it was a lot of moving parts to explain to anyone new.
Tomas Vondra: Being considerate of other people's time
If I could give one piece of advice to the past me, starting to contribute to open source projects, it’d be to value other developers' time more. It took me a while to appreciate the “economy” behind this, and adjust how I work to increase my chance of getting patches done. Hopefully some new contributors could learn from my mistakes.
Christophe Pettus: All Your GUCs in a Row: max_pred_locks_per_page and max_pred_locks_per_relation
Mikhail Shytsko: Forty Deletes Vanished From pg_stat_statements
On the server this article was written against, pg_stat_statements_info.dealloc reads 20, and that counter is all the database has left to say about forty rows an agent deleted. The forty entries were there while the DELETE statements ran, one per table, counted and timed like anything else. Then the same agent read the schema twice over, 12 800 statements that changed not one row, and the reading needed room.
Chris van Eijk: Multi-tenant SaaS on PostgreSQL: six decisions
Bruce Momjian: The Promise of Non-Volatile Memory
Relational databases like Postgres provide many unique features, specifically atomicity, consistency, isolation, and durability (ACID), but providing durability has always been a challenge. Though computers originally used non-volatile magnetic-core memory, the past five decades have been dominated by computer architectures where CPU-accessible memory is volatile, and OS-accessible storage is non-volatile/durable.
Cornelia Biacsics: Contributions for week 37
On 16 September 2026, the Postgres Meetup for All user group met, organized by Elizabeth Christensen and Ryan Booz. Ryan Booz and Greg Potter delivered a talk.
Christophe Pettus: All Your GUCs in a Row: max_parallel_apply_workers_per_subscription
Tejaswi Thimmaiah: PostgreSQL Major Version Upgrade with pg_upgrade and Extensions — A Hands-On Sandbox Guide
- Set Up the PostgreSQL Upgrade Sandbox
- Pre-Upgrade Assessment — Know Your Cluster First
-
Christophe Pettus: All Your GUCs in a Row: max_parallel_workers and max_parallel_workers_per_gather
Neither of these parameters means what its name says. max_parallel_workers_per_gather is the most workers the planner is allowed to request for one plan node, and the planner usually requests fewer. max_parallel_workers is documented as a limit for the whole cluster, and it is enforced by compari…
Henrietta Dombrovskaya: Major updates to pg_acm
I did it! The most important thing I anticipated after leaving DRW was having more time for important work, and one of the top items on my to-do list was the pg_acm update.
I already knew about two dozen bugs I needed to fix; several new functions people asked about. In addition, I had several conceptual changes in mind. Do you know how disturbing it is when you know you need to do something, and you can’t focus on that “something” because other things, less important but more urgent, keep popping up?
Christophe Pettus: All Your GUCs in a Row: max_parallel_maintenance_workers
Mark Wong: Sizing an OLTP TPC-E-like workload, Part 1
I used AI tools to size an OLTP workload on an EC2 system, with DBT-5, a TPC-E-like fair-use implementation. I provided a systematic and mechanical plan for running a series of tests to determine what the appropriate scale factor is on a system.
Ruohang Feng: PostgreSQL's Chinese Error Messages Were Seven Years Stale. Not Anymore.
Chris van Eijk: Row-level security in PostgreSQL: where tenants leak
Shaun Thomas: Looking Forward to Postgres 19: Epilogue
The future of Postgres is bright. So bright in fact, that I spent almost a dozen posts expounding on the upcoming features it would bring, with veritable stars in my eyes. Unfortunately, while I was out counting my chickens, it would seem some of these exciting new features failed to hatch.How, and perhaps more importantly why that happened, deserves some investigation.
Jimmy Angelakos: postgres.scot is live, August PostgresEDI meetup
Postgres events in Scotland now have a permanent address: postgres.scot
