#590 — February 27, 2025 |
|
Postgres Weekly |
![]() |
(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. Paul Copplestone (Supabase) |
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 PostgreSQL Global Development Group |
![]() 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. pganalyze sponsor |
QUICK BITS:
|
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. Tom Linford |
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). Elvis Pranskevichus (Gel) |
📄 Use 📄 Building RAG Systems in Go with Ent, Atlas, and pgvector Rotem Tamir (Ent) 📄 How Postgres' Aggregate |
🛠 Code and Tools |
![]() |
pg_activity 3.6: Dalibo |
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. Bemi Technologies, Inc. |
|