#654 — June 24, 2026 |
|
Postgres Weekly |
|
|
Looking Ahead to Postgres 19 — “Postgres 19 feels like one of those releases that has a bit of everything,” says Craig, who focuses on quality of life improvements that day-to-day Postgres users will come to appreciate, both at the operational level (e.g. Craig Kerstiens |
💡 Shaun Thomas digs into Postgres 19's logical replication of sequences. |
44 Recorded PostgreSQL Talks Are Now Available to Watch — POSETTE: An Event for Postgres 2026 is over, but the talks are here to stay. All sessions are now available on YouTube, so you can learn directly from Postgres experts at your own pace. Access the full playlist of 44 talks. Microsoft | AMD sponsor |
|
▶ What's Missing in Postgres? — We report on features Postgres is adding all the time, but what’s ‘missing’ and why? Bruce touches on a diverse range from sharding and connection pooling to columnar storage and transparent data encryption. Can’t watch? Here are the slides in PDF form. Bruce Momjian |
|
Postgres 18 Performance Enhancements — Postgres 18 has many enhancements and performance tweaks worth reviewing. This tour covers skip scan optimization, Self-Join Elimination, autovacuum settings, and more. It takes an AWS perspective, but most of it applies to anyone on Postgres 18. Jafri, Bedi, Burman and Shaik (Amazon) |
|
pg_stats: How Postgres Internal Stats Work — Get a working understanding of what Richard Yen |
|
📄 Optimizing Polymorphic Associations in Postgres Andrei Lepikhov 📄 Shipping 📄 Looking Forward to Postgres 19: Query Hints Shaun Thomas |
|
|
RELEASES AND CODE: |
|
|
Cybertec |
|
🌐 Datum: Local-First Spatial Syncing for PostGIS — A local-first sync layer that mirrors Postgres/PostGIS tables into an in-browser PostGIS instance (via the WASM-based PGlite) with real-time deltas over Abdulrhman Elsaed |
|
Migration Autopilot: GitHub Action to Review DB Migration PRs — Looks at database migrations and detects the renaming or dropping of columns and tables, truncation, and similar issues. Isabelle Hue |
|
|
Got a new email? You can change your address here. Bored of us? Click here to stop getting Postgres Weekly. Got a link for us? Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! Published by Cooper Press Ltd. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. |


