Scaling Postgres to 226k TPS: A Christmas Day Retrospective — A meaty post-mortem and tactical walkthrough of how a digital photo-frame company went from having its Postgres deployment crash out during the 2024 holiday season to handling 2025 without a hitch.

Andrew Atkinson

Learn How CERN Runs 40% Faster Queries on 95% Less Storage — CERN's 800+ SCADA systems generate hundreds of GB of time-series data daily. See how their engineers achieved 95% storage reduction and 40% faster queries with TimescaleDB — inside Postgres. Jun 25, 9 AM ET.

Tiger Data (creators of TimescaleDB) sponsor

The Only Scalable Delete in Postgres is DROP TABLE — A reminder that large DELETE operations cost more than you think, and how refactoring to a DROP or TRUNCATE can help in some cases.

Tom Pang (PlanetScale)

🕒 British Columbia, Time Zones, and Postgres — British Columbia switched to permanent daylight saving time in March, providing an illustration of a subtle timestamptz trap: future local times stored before a tzdata update come back an hour wrong! Here’s how to avoid getting caught out.

Christopher Winslett (Crunchy Data)

pg_durable: Durable Execution Inside Postgres — Microsoft has open sourced the durable workflow engine it uses in Azure HorizonDB. There are two Docker images running on Postgres 17/18 to experiment with, and full docs here.

Microsoft

pg_ducklake 1.0: A Native Lakehouse in Postgres — An extension that brings columnar storage, vectorized execution, and lakehouse architecture (data lake with a catalog) to Postgres, built with DuckDB and DuckLake.

Relyt