Postgres Weekly
Plus Postgres 18 performance enhancements, a new backup tool from CYBERTEC, and what pg_stats does for us.

#​654 — June 24, 2026

Web Version

Together with  Microsoft logo

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. REPACK and partitioning improvements) and in SQL (e.g. SQL/PGQ and GROUP BY ALL).

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 pg_stats is, and how it shapes the query planner's decisions.

Richard Yen

📄 Optimizing Polymorphic Associations in Postgres Andrei Lepikhov

📄 Shipping psql Without psql: A Pure-TypeScript Client in neonctl Vadim Kharitonov (Neon)

📄 Looking Forward to Postgres 19: Query Hints Shaun Thomas

📰 Classifieds

❄️ ColdFront Beta: Auto-tier old Postgres data to Iceberg on S3. Same table, same SQL. Cold data stays writable. Open source.


Run AI agents like microservices — agents with auto-generated APIs, durable memory, policy-based orchestration. No glue code. Open source. → Star on GitHub.

RELEASES AND CODE:

pg_hardstorage 1.0: A New Backup and Recovery Approach — A streaming-first, host-access-free, chain-free backup tool in a single binary that streams the WAL over an ordinary replication connection for gap-free, byte-precise PITR. It includes pgBackRest and Barman shims so you can swap it in/try it out without rewriting your automation.

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 NOTIFY.

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

  • SPQR 3.0Stateless Postgres Query Router for horizontal scaling via sharding. v3.0 adds distributed query support, distributed and reference tables, and two-phase commit for DDL/migrations across shards.

  • pgrx v0.19 – Framework for building Postgres extensions in Rust. v0.19 adds Postgres 19 Beta support, updates dependencies, and includes tidy-ups.

  • pgAdmin 4 9.16 – Popular web-based Postgres management tool.

  • pg_parse 0.15.0 – Postgres SQL parser for Rust.

Issue 653 #654