--- title: "Postgres vs. everything else" publication: "Postgres Weekly" issue: 656 published_at: "2026-07-08" canonical_url: "https://postgresweekly.com/issues/656" --- Plus a deadlock bug in Postgres 14-16, C64 BASIC in Postgres, and a fresh round of events. #​656 — July 8, 2026 [Web Version](https://postgresweekly.com/issues/656) Together with [![ParadeDB\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_164/e_make_transparent/co_white,e_outline:17/cdd8ciarsq6m8xam8oc3.png)](https://paradedb.com/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gh9d0pk0nfoal8f00czz.jpg)](https://postgresisenough.dev/) [Postgres is Enough: How Postgres Can Replace Other Things](https://postgresisenough.dev/) — A perennial topic in the Postgres world is figuring out just how many other systems (like Redis, Elasticsearch and Kafka, say) Postgres can step in for. This directory rounds up 89 extensions and tools that help Postgres do just that. Goodway [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/4df60f58.png)](https://paradedb.com/) [Search Without a Second System](https://paradedb.com/) — One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch. ParadeDB sponsor [Postgres Transactions are a Distributed Systems Superpower](https://www.dbos.dev/blog/co-locating-workflow-state-with-your-data) — Should workflow state live in a separate orchestrator, or in Postgres alongside your data? DBOS argues the latter: each step's checkpoint and database updates commit in one transaction, giving exactly-once semantics for those updates with no idempotency bookkeeping. Kraft and Li (DBOS) 💡 [DBOSify](https://github.com/dbos-inc/dbosify-py) puts the idea above into practice as a drop-in replacement for Temporal's Python SDK that uses Postgres with no Temporal server needed. [Why PgDog Built Yet Another Postgres Connection Pooler](https://pgdog.dev/blog/why-yet-another-connection-pooler) — Reducing user tradeoffs and providing a seamless experience, largely. For example, unlike PgBouncer, it keeps `SET` and `LISTEN`/`NOTIFY` working in transaction mode. Lev Kokotov 🚨 [A Replication Deadlock Bug in Current Postgres 14-16 Releases](https://www.credativ.de/en/blog/postgresql-en/replication-deadlock-bug-in-current-postgres-releases-14-16/) — A report that v14.23, v15.18, and v16.14 introduced a regression that can lead to a `MultiXactOffsetSLRU` deadlock during transaction log replay in some circumstances. Credativ [Waiting for Postgres 20: Add Backend-Level Lock Statistics](https://www.depesz.com/2026/07/06/waiting-for-postgresql-20-add-backend-level-lock-statistics/) — Postgres 19 isn't here yet, but Hubert's looking forward to v20 and its forthcoming per-backend lock statistics, which will show which connections are stuck waiting on locks, and for how long. Hubert 'depesz' Lubaczewski 📄 [Understanding Postgres 19 Property Graphs](https://neovintage.org/posts/postgres-property-graphs/) – A deeper look at mapping relational schemas onto [property graphs](https://www.cybertec-postgresql.com/en/handling-graphs-with-sql-pgq-in-postgresql/), gotchas included. Rimas Silkaitis 📄 [Looking Forward to Postgres 19: Split Personality](https://www.pgedge.com/blog/looking-forward-to-postgres-19-split-personality) – `ALTER TABLE` is gaining `SPLIT PARTITION` and `MERGE PARTITIONS` options. Shaun Thomas 📄 [Using Postgres as a Temporal Database](https://xata.io/blog/postgres-as-a-temporal-db) Gulcin Yildirim Jelinek (Xata) 📄 [Some More Thoughts on `random_page_cost`](https://vondra.me/posts/some-more-thoughts-on-random-page-cost/) Tomas Vondra **RELEASES AND CODE:** [pREST 2.0: Serve a RESTful API From a Postgres Database](https://github.com/prest/prest) — Turn a Postgres database into a RESTful API. Covers similar ground to [PostgREST](https://postgrest.org/en/stable/) but built in Go rather than Haskell. v2.0 adds [support for multiple databases](https://github.com/prest/prest/pull/973). pREST Team [PL/Ruby 2.5: Ruby as a Procedural Language for Postgres](https://github.com/commandprompt/plruby) — Lets you write functions, triggers, event triggers, and procedures for Postgres in Ruby. Joshua D. Drake (Command Prompt Inc.) [PL/CBMBASIC: Commodore 64 BASIC for Postgres](https://thombrown.blogspot.com/2026/07/load-plcbmbasic81-commodore-64-basic.html) — I like to slip a fun item in every now and then, and it doesn't get more fun than writing Postgres functions in a 44-year-old programming language.. does it? 😅 Thom Brown [Tinbase: A Supabase-Compatible Backend in a Single Binary](https://github.com/tinbase/tinbase) — An experiment that provides a local Supabase-like dev experience without Docker using a pure-JS backend built on [PGlite](https://pglite.dev/) and [pg-mem](https://github.com/oguimbal/pg-mem). A sort of mini, local-only Postgres wrapped in the same APIs as Supabase proper, so `supabase-js` works unchanged. Sanket Sahu [pglayers: Postgres Extensions as Docker Layers](https://pglayers.github.io/) — The official Postgres Docker images ship with few extensions and adding more can become tricky. pglayers tries to make this easier by layering extensions atop the official image. Ismaël Mejía - [pgcopydb 0.18](https://tapoueh.org/blog/2026/07/pgcopydb-v0.18/) – Copy a Postgres database to a target server (a turbocharged `pg_dump | pg_restore`, if you will). - [PostGIS 3.7.0 Alpha 1](https://postgis.net/2026/07/PostGIS-3.7.0alpha1/) – `ST_DWithin` gets a major speed boost, Postgres 12/13 support is dropped, `address_standardizer` and `tiger_geocoder` are spun out into their own repos. - [River 0.40](https://github.com/riverqueue/river/releases/tag/v0.40.0) – Job processing system for Go using Postgres. Contains a schema cleanup migration and adds `JobStuckHandler` as a hook for handling stuck jobs. 📰 Classifieds 📊 [OSS observability for any Postgres 14+](https://github.com/pgEdge/ai-dba-workbench). Tiered anomaly detection, historical metrics. Natural-language chat optional. --- [No more sales calls for Postgres](https://store.enterprisedb.com/category/shop-database-options/0ZGPP0000004HVJ4A2?utm_source=newsletter&utm_medium=email&utm_campaign=em_ww_vcop_ecommerce-20260625). Pick your product, check out, and scale on your own terms. [No waiting on a quote](https://store.enterprisedb.com/category/shop-database-options/0ZGPP0000004HVJ4A2?utm_source=newsletter&utm_medium=email&utm_campaign=em_ww_vcop_ecommerce-20260625). 🗓 **Upcoming Postgres Events** - 🇲🇬 [PostgreSQL Madagascar Conference 2026 (July 18)](https://pugmg.github.io/pgconf-antananarivo-2026/) — The second in-person Madagascar Postgres conference, with talks in Malagasy, French, and English. - 🇬🇧 [PGDay UK 2026 (September 8 in London)](https://2026.pgday.uk/) — The fourth annual PGDay UK, run in partnership with PGDay Lowlands. - 🇪🇺 [PGConf.EU 2026 (October 20-23 in Valencia, Spain)](https://2026.pgconf.eu/) — The biggest Postgres event in Europe. - 🇦🇺 [PG Down Under 2026 (October 30 in Sydney)](https://conf.pgdu.org/conferences/2026/) — The sixth annual conference for Postgres folks in Australia and New Zealand. [Its CFP is open](https://conf.pgdu.org/conferences/2026/program/proposals/new) until next week (July 15). - 🇭🇰 [PGCONF.ASIA 2026 (November 17-18 in Hong Kong)](https://pgconf.asia/EN/2026/) — A leading conference in Asia. The CFP is currently open. - 🇵🇱 [PGConf.PL 2026 (November 24 in Gdańsk)](https://2026.pgconf.pl/) — The inaugural PostgreSQL conference for Poland and Central Europe. _Note: This list is not exhaustive, and we will continue to mention and promote other events over time._ **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|*).