#598 — May 1, 2025 |
|
Postgres Weekly |
![]() |
PGlite 0.3: Postgres on WASM, Now Based on Postgres 17 — PGlite is a WebAssembly-based build of Postgres that enables you to run an instance of Postgres wherever WebAssembly can be run (such as in the browser as in this demo). v0.3 takes a big step forward in moving up to Postgres 17.4. (GitHub repo.) ElectricSQL |
What Really Happens When You Drop a Column — When you run a Gwen Shapira |
![]() Is Your Application Prepared for Your Next High Traffic Event? — Are you tired of your Postgres database feeling like a black box? Watch Postgres expert Lukas Fittl walk through the latest pganalyze features to tune slow queries, catch regressions, and keep Postgres running at its best in this on-demand video. pganalyze sponsor |
Jepsen: Amazon RDS for PostgreSQL Multi-AZ Clusters Violate Snapshot Isolation — Jepsen is well known for its analysis of distributed systems. After some experimentation, the author found that Amazon RDS for PostgreSQL multi-AZ clusters (specifically) violate Snapshot Isolation, the strongest consistency model supported across all endpoints. Kyle Kingsbury |
Why All Your Workflows Should Be Postgres Rows — It may be no surprise the folks behind the DBOS durable execution/workflow library think storing workflows in Postgres is a good idea, but here’s how they think about it from a schema POV. Kraft and Li (DBOS) |
📄 A Postgres Planner Gotcha with CTEs, 📄 Trusted Extensions Explained for Beginners Pavlo Golub 📄 Postgres to ClickHouse: Data Modeling Tips Palacin and Srirampur (ClickHouse) |
QUICK RELEASES:
|