--- title: "Postgres 19 now due November 19" publication: "Postgres Weekly" issue: 669 published_at: "2026-10-14" canonical_url: "https://postgresweekly.com/issues/669" --- Plus a new vector index that isn't HNSW, how savepoints throttled a queue, and a key PgBouncer security fix. #​669 — October 14, 2026 [Web Version](https://postgresweekly.com/issues/669) Together with [![Redis\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_407/e_make_transparent/co_white,e_outline:9/uptt3apt4u1xbvjmctr9.png)](https://fandf.co/4hULh6C) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gn9k4gm9cggzc04p2iws.jpg)](https://www.tigerdata.com/blog/announcing-pg_vectorsearch-scalable-open-source-vector-search-postgresql) [pg_vectorsearch: A Partition-Based Alternative to HNSW](https://www.tigerdata.com/blog/announcing-pg_vectorsearch-scalable-open-source-vector-search-postgresql) — A vector search extension that uses PRISM, a vector index that scans compressed k-means partitions rather than walking a graph like HNSW, and works on existing `pgvector` columns. It's alpha and requires Postgres 18+, while [pgvectorscale](https://github.com/timescale/pgvectorscale) moves to maintenance mode. Erik Nordström et al. (Tiger Data) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/c105857a.png)](https://fandf.co/4hULh6C) [Agent Memory: Raw Retrieval Vs. Extracted Facts, Tested](https://fandf.co/4hULh6C) — Redis reran agent memory systems on LongMemEval. Published scores missed reproduced results by up to 28 points, and pairing raw conversation retrieval with extracted facts beat either approach alone. See the data, costs and methodology. Redis sponsor [How Savepoints Throttled Our Postgres Queue](https://incident.io/blog/how-savepoints-quietly-throttled-our-postgres-queue) — A technical look, complete with some rather nifty visualizations, into how adding more workers to a Postgres-based queue made it slower because of per-job `SAVEPOINT`s (and how claiming jobs with a lease fixed it). Rory Malcolm (incident.io) **IN BRIEF:** - ⭐ [Postgres 19's release has been pushed back](https://www.postgresql.org/message-id/f161fbb7-e193-42eb-bec7-4cfc1af74a50%40postgresql.org) to November 19, with an extra RC2 on November 12 to include many more recent fixes. The first release candidate still lands tomorrow (October 15). - ⚠️ [PgBouncer 1.26.1](https://www.pgbouncer.org/2026/10/pgbouncer-1-26-1) fixes three CVEs, the worst letting a client who knows one user's password log in as a different user (even a superuser) when SCRAM auth is in use. ['The Reverts Will Continue Until Morale Improves'](https://peter.eisentraut.org/blog/2026/10/09/the-reverts-will-continue-until-morale-improves) — A Postgres committer, whose own work was among the casualties, shares his take on why so many Postgres 19 features were reverted during beta. Peter Eisentraut 📊 Meanwhile, Kaarel Moppel [ran 800 hours of benchmarks on the Postgres 19 betas](https://kmoppel.github.io/2026-10-09-postgres-v19-oltp-perf-check/) and found them a few percent faster than v18 on OLTP workloads. [Don't Bet on `SELECT` Order: Shuffle Your Rows and See What Folds](https://evilmartians.com/chronicles/dont-bet-on-select-order-shuffle-your-rows-see-what-folds) — If your app or tests implicitly rely on rows returning in insertion order, that can cause many an annoying bug (I've been bitten myself!). The [pg_disorder](https://github.com/viralpraxis/pg_disorder) extension shuffles `SELECT` results lacking an `ORDER BY` to catch such bugs in testing. Yaroslav Kurbatov (Evil Martians) [What Deleting Rows Does to a Table](https://explainmeasured.com/posts/deleting-rows/) — A tidy explainer and demo covering a common misunderstanding. Deleting half a table's rows, then running `VACUUM`, left it at 137 MB on disk, with only `VACUUM FULL` reclaiming it. Hollis Varden 📄 [Why Setting `archive_command` to `/bin/true` Can Lose Data](https://www.pgedge.com/blog/pg-phriday-against-the-wal) – The 'fix' for a full WAL disk that breaks recovery without warning. Shaun Thomas 📄 [PgBouncer Pooling Modes in Practice](https://event-driven.io/en/connection-pooler-modes-advisory-locks/) – What transaction pooling does to your advisory locks. Oskar Dudycz 📄 [PgBouncer vs. Amazon RDS Proxy: How the Two Poolers Differ](https://aws.amazon.com/blogs/database/understanding-the-differences-between-pgbouncer-and-amazon-rds-proxy-for-postgresql-connection-pooling/) Wood and Chiba (AWS) 📄 [How `TABLESAMPLE` Picks Rows](https://boringsql.com/posts/tablesample/) Radim Marek 📰 Classifieds RDST's always-on agent watches every PG query, automatically sends you explained fixes, and verifies they worked once applied. [Put an agent to work on your Postgres database. It's free](https://readyset.io/downloads?utm_source=postgresweekly&utm_medium=newsletter&utm_campaign=postgresweekly_sponsorship&utm_content=2026-10-14). --- ⚡[Rebase](https://rebase.pro/?utm_source=postgresweekly&utm_medium=newsletter&utm_campaign=2026-10-14): An open-source backend for Postgres. REST, a typed SDK, auth, realtime, storage, and an admin panel you don't have to build. --- [Try ClickHouse Managed Postgres](https://clickhouse.com/campaigns/clickhouse-managed-postgres?utm_source=postgres-weekly&utm_medium=sponsored-content&utm_campaign=2026-10-14_Classified_Clickhouse): Up to 10x faster for I/O-heavy workloads on local NVMe, with native ClickHouse integration. **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/h6i6uifi9p9kdurhphne.jpg)](https://supabase.com/blog/declarative-schemas-2-0-pg-delta) [pg-delta: Diff Postgres Schemas Into Ordered Migrations](https://supabase.com/blog/declarative-schemas-2-0-pg-delta) — Supabase's new open source schema diff engine. Point it at two Postgres 14–18 databases and get an ordered migration covering RLS policies, grants and domains. It replaces the deprecated `migra`, but is still _alpha_. Valleteau and Xie (Supabase) [asyncpg 0.32.0: Fast Postgres Client Library for Python/asyncio](https://github.com/MagicStack/asyncpg) — The long-standing Python client library for use with the `asyncio` framework now supports Postgres 19, as well as the newly released Python 3.15. MagicStack [Orafce: Oracle Compatibility Functions for Postgres](https://github.com/orafce/orafce#readme) — Implements some of the functions from Oracle that might be useful for users migrating to Postgres. We haven’t linked to this in a few years but it continues to get frequent releases. Orafce Project - [wal2json 2.7](https://github.com/eulerto/wal2json/releases/tag/wal2json_2_7) – A logical decoding plugin that emits row changes as JSON, used by many change data capture setups. This first release in over two years adds Postgres 18 and 19 support. - [PGQueuer 1.6](https://github.com/janbjorge/pgqueuer/releases/tag/v1.6.0) – A Python job queue library built on Postgres. - [Squawk 2.68](https://github.com/sbdchd/squawk/releases/tag/v2.68.0) – A linter for Postgres schema migrations. **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|*).