~postgresweekly | Issue 590 - Bruce Momjian's Postgres tour (7)

(Ab)using pgRouting to Use Postgres as a Graph Database — pgRouting is an extension for providing geospatial routing functionality, commonly along with PostGIS. But, surprisingly, its graph and path searching mechanisms can be used to navigate any data structured in a graph-like form.

Postgres 17.4, 16.8, 15.12, 14.17, and 13.20 Released — This makes two bumps to all maintained release lines in as many weeks (this is an 'out of cycle' release – explained here). As before, the focus is bug fixes. Postgres 17 gets fixes for a memory leak in pg_createsubscriber and a tweak to quoting function behavior in libpq.

Don’t Let Postgres Maintenance Slip Through the Cracks & Let Performance Fall Off a Cliff — Secure your spot to learn the proactive maintenance & monitoring practices to uncover hidden performance risks in your database, such as slow queries, checkpoint behavior, and connection issues, before they escalate, & ensure your database reliability.

While Postgres Redlined, Robinhood Sharded to Scale — A short write up, from an engineer who used to work at Robinhood, about Postgres scaling problems the company encountered and how sharding was their savior.

EdgeDB is Now Gel (and Postgres is the Future) — Gel (formerly EdgeDB) is an ‘integrated data platform on top of Postgres’ that provides its own query language in an attempt to work around SQL’s perceived flaws (better explanation here).

pg_activity 3.6: top-Like Activity Monitoring Tool — Much as you might use top or htop to monitor processes and CPU usage, pg_activity gives you a similar look behind the scenes of Postgres with views over running queries, up to date performance stats, and more.

BemiDB: Zero-ETL Data Warehouse for Postgres — Open source (GitHub repo) but with a commercial angle for more enterprise-y features, BemiDB, written in Go, acts as a Postgres read replica (so all your data is synced in automatically) optimized for analytics workloads.