~postgresweekly | Issue 598 - A WebAssembly build of Postgres 17 (5)

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.)

What Really Happens When You Drop a Column — When you run a ALTER TABLE .. DROP COLUMN you probably don’t think too hard about what’s going on behind the scenes, but sometimes specifics of the process can rear their ugly head. In short, ‘dropped’ columns may be gone but not forgotten.

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.

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.

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.