#658 — July 22, 2026 |
|
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 |
|
|
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, 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 |
|
|
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. |

