--- title: "A Kafka-like pure SQL queue for Postgres" publication: "Postgres Weekly" issue: 645 published_at: "2026-04-22" canonical_url: "https://postgresweekly.com/issues/645" --- Plus Xata open sources its core technology, and a developer's attempt to rewrite Postgres in Rust. #​645 β€” April 22, 2026 [Web Version](https://postgresweekly.com/issues/645) Together with [![Tiger Data logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_282/e_make_transparent/co_white,e_outline:30/px1u7kjyvz7xnbm6ytir.png)](https://www.tigerdata.com/timescaledb?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/obmbrc1smyax7fktvtuk.jpg)](https://www.postgresql.org/docs/devel/release-19.html) πŸ“ [The First Draft of the PostgreSQL 19 Release Notes](https://www.postgresql.org/docs/devel/release-19.html) β€” Bruce has [just completed](https://momjian.us/main/blogs/pgblog/2026.html#April_15_2026) the first, bulletpoint-heavy draft of the release notes for Postgres 19, [targeted to land](https://www.postgresql.org/developer/roadmap/) this September with a beta [expected](https://www.postgresql.org/developer/beta/) in the coming months. Bruce Momjian πŸ’‘If you fancy seeing the process behind the notes, Bruce [made this wiki page.](https://wiki.postgresql.org/wiki/Creating_Major_Release_Notes) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/5b61f081.png)](https://www.tigerdata.com/timescaledb?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter) [Your Hot Table Hit a Billion Rows. Now What?](https://www.tigerdata.com/timescaledb?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter) β€” TimescaleDB chunks growing tables automatically, compresses cold data up to 95%, and pre-computes rollups with continuous aggregates. All in native Postgres. No new query language, no second database, no migration. [Start building for free](https://www.tigerdata.com/timescaledb?utm_source=content-syndication&utm_medium=referral&utm_campaign=postgres-weekly-newsletter). Tiger Data (creators of TimescaleDB) sponsor [Introducing Xata OSS: A Postgres Platform with Branching, Now Apache 2.0](https://xata.io/blog/open-source-postgres-branching-copy-on-write) β€” [Xata](https://xata.io/) has made the core technology of its Postgres platform open source. You get copy-on-write branching at the storage layer that clones databases in seconds, scale-to-zero for inactive branches, while still having standard Postgres underneath. Tudor Golubenco / Xata **IN BRIEF:** - πŸ€– A developer is [attempting to 'rebuild Postgres in Rust'](https://malisper.me/pgrust-rebuilding-postgres-in-rust-with-ai/) using AI agents because... why not? A third of Postgres's tests pass so far, and there's [a live online demo here.](https://pgrust.com/) - Cloudflare teases a development, landing next month, in its partnership with PlanetScale: [the ability to deploy PlanetScale-hosted databases directly from the Cloudflare dashboard](https://blog.cloudflare.com/deploy-planetscale-postgres-with-workers/) for use with _Workers_. - πŸ‡ΊπŸ‡Έ [PGDay Boston 2026](https://2026.pgdayboston.org/) takes place this June 9 in Boston with Michael Stonebraker, the original leader of the Postgres project, giving a keynote address. - πŸ‡¨πŸ‡­ [Swiss PGDay 2026](https://2026.pgday.ch/) is this June 25-26 in Rapperswil, Switzerland. πŸ“‰ [Investigating the Linux 7.0 Postgres Throughput Regression](https://mydbanotebook.org/posts/postgres-performance-regression-are-we-there-yet/) β€” We recently featured an article about [how Linux 7.0 was affecting Postgres performance](https://www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop) _on certain setups._ LΓ¦titia digs into what the actual issue is, who’s affected (very few of us!) and what to keep in mind when you upgrade. LΓ¦titia Avrot [How CTIDs Gave Me a 30x Speedup on Processing 200 Million Rows](https://connorhallman.com/blog/ctid-batch-processing) β€” A look at where index scans can fail at scale on large static tables, how the internal `ctid` (physical row address) enables true sequential I/O, and a full implementation with visualizations of the access pattern difference. Connor Hallman [When Upserts Don't Update But Still Write](https://www.datadoghq.com/blog/engineering/debugging-postgres-performance/) β€” How Datadog traced doubled disk writes and quadrupled WAL syncs to a surprising behavior: `ON CONFLICT DO UPDATE` locks the conflicting row even when the `WHERE` condition means nothing is actually updated. Anthonin Bonnefoy (Datadog) πŸ“„ [Using Non-ACID Storage as a Workaround for a Lack of Autonomous Transactions](https://okbob.blogspot.com/2026/04/using-non-acid-storage-as-workaround.html) Pavel Stehule πŸ“„ [Waiting for Postgres 19: Online Enabling and Disabling of Data Checksums](https://www.depesz.com/2026/04/15/waiting-for-postgresql-19-online-enabling-and-disabling-of-data-checksums/) Hubert Lubaczewski πŸ“„ [Finding Invisible Use-After-Free Bugs in the Postgres Planner](https://danolivo.substack.com/p/finding-invisible-use-after-free) Andrei Lepikhov πŸ“° Classifieds πŸš€ Triple your Postgres productivity. [pgEdge AI DBA Workbench](https://www.pgedge.com/download/ai-dba-workbench): AI monitoring & diagnostics for ANY Postgres v14+. [Open source](https://www.pgedge.com/download/ai-dba-workbench). --- [Collect real-time search data at scale](https://serpapi.com/playground/?utm_source=cooperpress&utm_campaign=postgres_classified) with an API built for analysts, engineers, and AI teams. **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ellyzyxvxf7hgck3wsqi.jpg)](https://github.com/NikolayS/pgque) [PgQue: A Pure SQL + PL/pgSQL Zero-Bloat Postgres Queue](https://github.com/NikolayS/pgque) β€” From a long-time Postgres contributor comes a modern version of Skype’s [PgQ](https://github.com/pgq/pgq) in _β€˜one SQL file + `pg_cron`’_ form. Architecturally closer to Kafka than a typical job queue with zero event-table bloat, native fan-out, and no `SKIP LOCKED`. Nikolay Samokhvalov πŸ’‘ PgQue attracted [some discussion on Hacker News](https://news.ycombinator.com/item?id=47817349) where Nikolay answered a variety of questions. [Apache Cloudberry 2.1: A Postgres-Based MPP Database](https://cloudberry.apache.org/) β€” An MPP (Massively Parallel Processing) database splits data and query execution across many nodes; a big win for analytics workloads. Cloudberry carries on work started with [Greenplum](https://en.wikipedia.org/wiki/Greenplum), but on a more modern Postgres kernel. [GitHub repo.](https://github.com/apache/cloudberry) Apache Software Foundation πŸ”₯ [pg_roast: An Extension That Audits and 'Roasts' Your Database](https://github.com/samirketema/pg_roast) β€” Built upon principles from the book [PostgreSQL Mistakes and How to Avoid Them](https://www.manning.com/books/postgresql-mistakes-and-how-to-avoid-them). Samir Ketema - πŸ”Ž [pg-index-health-sql 0.40](https://github.com/mfvanek/pg-index-health-sql) – SQL queries for analyzing & maintaining indexes and tables. [pg-index-health 0.40](https://github.com/mfvanek/pg-index-health) is the same, but as a Java library. - [credcheck 4.7](https://www.postgresql.org/about/news/credcheck-v47-has-been-released-3277/) – Extension that validates credentials during user creation or renaming and password changes. - [pgwire 0.39](https://github.com/sunng87/pgwire/releases/tag/v0.39.0) – The Postgres wire protocol as a Rust library for writing Postgres-compatible servers and clients. - [PostgREST 14.10](https://github.com/PostgREST/postgrest) – Serve up a fully RESTful API from a Postgres database. - [River 0.35](https://github.com/riverqueue/river) – Robust job processing system for Go using Postgres. - [PgDoorman 3.5](https://github.com/ozontech/pg_doorman/releases) – Multithreaded connection pooler built in 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|*).