--- title: "Bruce Momjian's Postgres tour" publication: "Postgres Weekly" issue: 590 published_at: "2025-02-27" canonical_url: "https://postgresweekly.com/issues/590" --- Plus turning Postgres into a graph database with a routing extension. | #​590 — February 27, 2025 [Web Version](https://postgresweekly.com/issues/590) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AqcMXdJyGsYKNR8-29OpOhW7INVaV4KtoVePJ_ueaHr5detmNKrb5yKAIMWH0aNFyZ907FVyMl1pfyDEqP0I6sbCpg) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/w3pouwxokxckx0tukifx.jpg)](https://supabase.com/blog/pgrouting-postgres-graph-database) [(Ab)using pgRouting to Use Postgres as a Graph Database](https://supabase.com/blog/pgrouting-postgres-graph-database) — [pgRouting](https://pgrouting.org/) 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](https://www.postgresql.org/about/news/postgresql-174-168-1512-1417-and-1320-released-3018/) — This makes two bumps to all maintained release lines in as many weeks (this is an 'out of cycle' release – [explained here](https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-february-20-2025-3016/)). 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`. PostgreSQL Global Development Group [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/3b2277d7.png)](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AqcMXdJyGsYKNR8-29OpOhW7INVaV4KtoVePJ_ueaHr5detmNKrb5yKAIMWH0aNFyZ907FVyMl1pfyDEqP0I6sbCpg) [Don’t Let Postgres Maintenance Slip Through the Cracks & Let Performance Fall Off a Cliff](https://events.zoom.us/ev/AlEFPGvPxH6KNfpNmpZqz9VgcLKBd4PhtHLtfLFygO5sK3UqhQyd~AqcMXdJyGsYKNR8-29OpOhW7INVaV4KtoVePJ_ueaHr5detmNKrb5yKAIMWH0aNFyZ907FVyMl1pfyDEqP0I6sbCpg) — 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:** - 🌍 Have you ever wondered what goes on in the life of Bruce Momjian as he travels around the world evangelizing Postgres? [EDB's Caroline Pickens recaps Bruce's recent tour of several Postgres events](https://www.enterprisedb.com/blog/edbs-global-postgres-leadership) – he certainly has more energy (and better dress sense) than me! - The next version of Postgres is gaining the ability to [transfer statistics during`pg_upgrade`.](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1fd1bd871012732e3c6c482667d2f2c56f1a9395#transferstatistics) - [Laravel Cloud](https://app.laravel.cloud/) is a new, official hosting platform for apps built with the popular PHP framework. Its database layer? Serverless Postgres! - EDB commissioned an independent benchmark to put its Postgres-based database up against Oracle, SQL Server, MongoDB and MySQL in areas like price-vs-performance and raw speed. Unsurprisingly (since they released the results), [EDB's Postgres was faster and cheaper.](https://www.bigdatawire.com/2025/02/19/edb-says-it-tops-oracle-other-databases-in-benchmarks/) - 🇩🇪 [Registration for the 9th annual PostgreSQL Conference Germany](https://2025.pgconf.de/) is open. It takes place in Berlin this May. [While Postgres Redlined, Robinhood Sharded to Scale](https://tomlinford.com/posts/robinhood-sharding-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)](https://www.geldata.com/blog/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](https://www.geldata.com/blog/edgedb-1-0%20blog-edgedb-1-0#blog-edgedb-1-0)). Elvis Pranskevichus (Gel) 📄 [Use `PASSING` with `JSON_TABLE()` to Make Calculations](https://stokerpostgresql.blogspot.com/2025/02/use-passing-with-jsontable-to-make.html) Dave Stokes 📄 [Building RAG Systems in Go with Ent, Atlas, and pgvector](https://entgo.io/blog/2025/02/12/rag-with-ent-atlas-pgvector/) Rotem Tamir (Ent) 📄 [How Postgres' Aggregate `FILTER` Will Spoil You](https://stokerpostgresql.blogspot.com/2025/02/how-postgresqls-aggregate-filter-will.html) Dave Stokes 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/g3dqd4hiikvsvy8dyr9n.jpg)](https://github.com/dalibo/pg_activity) [pg_activity 3.6: `top`-Like Activity Monitoring Tool](https://github.com/dalibo/pg_activity) — 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. Dalibo [BemiDB: Zero-ETL Data Warehouse for Postgres](https://bemidb.com/) — Open source ([GitHub repo](https://github.com/BemiHQ/BemiDB)) 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. - [rsql 0.16](https://github.com/theseus-rs/rsql) – Modern Rust-based `psql`-esque CLI for working with Postgres, DuckDB, MySQL, Redshift, SQLite3, SQL Server, and other databases. - [PostgreSQL Embedded 0.18](https://github.com/theseus-rs/postgresql-embedded) – A mechanism to distribute and embed Postgres into other apps _"similar to what you would have with SQLite."_ - [River 0.18](https://github.com/riverqueue/river/releases/tag/v0.18.0) – Fast & reliable Postgres-powered background jobs for Go. - [pgrx 0.13](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.13.0) – A way to build Postgres extensions with Rust. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).