Postgres Weekly
Plus Postgres 19 beta 2, how TOAST compression works in Postgres 19, and is Postgres the database of the Backrooms?

#​658 — July 22, 2026

Web Version

Together with  Tiger Data logo

Postgres Weekly

Making 768 Servers Look Like 1 — A fun, educational animated explainer of how a petabyte of Postgres spread over 256 shards (each with a primary and two replicas) can present as one database, covering where replicas hit a wall, query-parsing routers, and load balancing.

Ben Dicken (PlanetScale)

VACUUM Wasn't Made for Append-Only Time-Series — TimescaleDB extends Postgres with hypertables that partition automatically as data grows, columnar compression that cuts storage up to 95%, and continuous aggregates that keep rollups fresh. Same Postgres, same SQL. Get $1000 credit to start.

Tiger Data (creators of TimescaleDB) sponsor

Don't Add a Read Replica Until You've Read This — A common issue with read replicas is stale reads, which can surface in unexpected places. incident.io explains the approach they used while moving most of their reads off their primary, including LSN stamping and query routing strategies.

Johanna Larsson

IN BRIEF:

Postgres 19 Compression: From pglz to LZ4 — In v19, TOAST compression switches by default from pglz to LZ4 (an option since Postgres 14). Christopher covers the history, but also the fun stuff: the decision tree for what gets compressed or TOASTed, and how indexes compress oversized keys.

Christopher Winslett

Turso: 'We're Building Postgres in Rust' — We've recently featured pgrust but now Turso, known for rewriting SQLite in Rust, is having a go too with an LLVM-inspired approach: a single database core that presents via multiple frontends, of which Postgres is the second.

Costa and Enberg (Turso)

▶  Working on Postgres After 13 Years on SQL Server — Microsoft's Panagiotis Antonopoulos discusses his transition from 13 years on SQL Server to Postgres, why Postgres has become the default choice for many workloads, and Azure HorizonDB's shared-storage architecture.

Talking Postgres podcast

📺 Making Iceberg Walk and Talk Like Postgres – A 5 minute lightning talk at DuckCon about pg_lake. Marco Slot

📄 How Much Do You Really Need to Know About Databases? Karen Jex

📄 Building the OAPE PostgreSQL Certification Cornelia Biacsics

📰 Classifieds

See what really breaks in an Oracle migration, from stored procedures to edge cases, and how AI agents handle it. Run it in your browser.


MyDBA: Comprehensive monitoring for your Postgres database. Kick off with a free week-long health check, then keep monitoring free.

RELEASES AND CODE:

pgBackRest 2.59.0 Released with Postgres 19 Support — The first release of the popular backup and restore tool since the project briefly died and came back to life. Getting ready for Postgres 19 is the focus, but some handy S3 and Azure enhancements have been added too.

David Steele

pg_timetable 7.0: Advanced Job Scheduling for Postgres — A mature, stand-alone job scheduler that stores its state in your database and lets you schedule tasks and chain them together. v7 adds OpenTelemetry tracing, arm64 support to the Docker image, and a way to enable/disable tasks.

CYBERTEC PostgreSQL International GmbH

💡 pgAdmin is working on a UI for working with pg_timetable tasks.

Puffgres: Keep Postgres Entities Synced with Turbopuffer — Ever heard of A24, the distributor of movies like Backrooms and Uncut Gems? Their first open source release is a Rust tool that uses logical replication to mirror Postgres entities to Turbopuffer, the cloud vector/full-text search service.

A24 Films

  • Nano ID for Postgres 3.0 – Tiny, secure, URL-friendly, unique string ID generator as a Postgres function. v3.0 has breaking changes and supports optional prefixes.

  • PGSync 7.2 – Middleware for Postgres to Elasticsearch/OpenSearch syncing.

  • pgstream 1.2 – Postgres replication with DDL changes. v1.2 adds a check command for preflight validation.

  • node-pg-migrate 9.0 – Schema migration management for Node.js apps.

  • 🌐 PostGIS 3.7.0 Beta 1 – Works with Postgres 14 through 19 beta 2.

Issue 657 #658