#​598 — May 1, 2025

Web Version

Together with  pgAnalyze

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

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, DELETE and LIMIT“What seemed straightforward turned out to have a surprising interaction with the query planner.” Shayon Mukherjee

📄 Trusted Extensions Explained for Beginners Pavlo Golub

📄 Postgres to ClickHouse: Data Modeling Tips Palacin and Srirampur (ClickHouse)

QUICK RELEASES:

  • DbGate 6.4 – Database manager app for both SQL and NoSQL databases. Now supporting DuckDB too.

  • pgAdmin 4 v9.3 – Popular, feature-rich administration tool.

  • pspg 5.8.9 – Unix terminal pager for tabular data.

  • Dbmate 2.27 – Framework-agnostic, Go-powered database migration tool.

  • Good Job 4.10 – Postgres-backed job queue for Ruby on Rails.