Public list by ~postgresweekly
https://www.crunchydata.com/blog/british-columbia-and-time-zone-changes
🕒 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.
2 months ago
https://pgducklake.select/blog/releasing-v1/
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.
2 months ago
https://planetscale.com/blog/the-only-scalable-delete
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.
2 months ago
https://andyatkinson.com/postgresql-rds-scaling-aws-christmas-day-peak
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.
2 months ago
https://talkingpostgres.com/episodes/how-i-got-started-running-a-postgres-user-group-with-jeremy-schneider
▶  How I Got Started Running a Postgres User Group — Jeremy Schneider joined Claire Giordano to discuss why local Postgres user groups are career “express lanes” and why the hard work of running one is worth it. Full transcript.
2 months ago
https://github.com/microsoft/pg_durable
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.
2 months ago
https://www.tigerdata.com/events/webinar-cern-2026
95% Less Storage. 40% Faster Analytics. CERN on Postgres — CERN's Large Hadron Collider generates hundreds of GB of time-series data daily. In this live webinar, their engineers walk through how they modernized a legacy archiving stack with TimescaleDB. June 25, 9 AM ET.
3 months ago