--- title: "Moving one word in a query unlocks a 32x speedup" publication: "Postgres Weekly" issue: 641 published_at: "2026-03-25" canonical_url: "https://postgresweekly.com/issues/641" --- Plus a new filesystem backed by Postgres, even faster JITing, and some Postgres events this April. #​641 — March 25, 2026 [Web Version](https://postgresweekly.com/issues/641) Together with [![Signando\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_363/e_make_transparent/co_white,e_outline:12/ffmffj6ylxpv22d9uqtt.png)](https://www.signando.com) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/c8b5irmunnl1pv85xfak.jpg)](https://neon.com/blog/ctrl-c-in-psql-gives-me-the-heebie-jeebies) [Ctrl-C in `psql` Gives Me the Heebie-Jeebies](https://neon.com/blog/ctrl-c-in-psql-gives-me-the-heebie-jeebies) — When you hit Ctrl-C in `psql`, the cancel request is sent _unencrypted_ over a separate connection, even if your main session uses TLS. This deep dive explains how `CancelRequest` works at the protocol level, a potential security risk, and why it operates in this way. George MacKerron (Neon) [Digging into `pg_plan_advice`: Query Plan 'Hints' for Postgres 19](https://www.depesz.com/2026/03/22/waiting-for-postgresql-19-add-pg_plan_advice-contrib-module/) — We [featured Robert Haas's explainer](https://rhaas.blogspot.com/2026/03/pgplanadvice-plan-stability-and-user.html) recently, but Hubert goes further with examples using his [explain.depesz.com](https://explain.depesz.com/) dataset, showing how this new module lets you capture, replay, and override key planner decisions. Hubert Lubaczewski [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/b4ab77b6.png)](https://www.signando.com) [Security Gateway for Postgres – Inspect Queries and Results](https://www.signando.com) — Protect your sensitive data with a second layer of defense in front of your PostgreSQL. Whitelist queries, inspect results, enforce SQL policies, and isolate your database network. Full bidirectional audit trail. No app changes required. Signando GmbH sponsor **IN BRIEF:** - Corey Quinn covers [AWS's recent ending of support for Postgres 13 on RDS](https://www.theregister.com/2026/03/17/aws_ends_support_postgresql_13_rds/). If you upgrade, take care: it can break [AWS Glue](https://aws.amazon.com/glue/). - 📘 _Supabase_ and _Manning Publications_ have published [Mastering Postgres: Accelerate Your Weekend Projects and Seamlessly Scale to Millions](https://blog.manning.com/mastering-postgresql-accelerate-your-weekend-projects-and-seamlessly-scale-to-millions), a free ebook _(though it's behind an email wall)._ - _PlanetScale_ has introduced a [Database Traffic Control](https://planetscale.com/blog/introducing-database-traffic-control) feature to manage database workflows according to a budget on the fly. [Here's how it works at a technical level.](https://planetscale.com/blog/behind-the-scenes-how-traffic-control-works) **EVENTS IN APRIL:** - 🇩🇪 Looking for a Postgres event to attend in April? Head over to [PostgreSQL Conference Germany 2026](https://2026.pgconf.de/) taking place in Essen on April 21-22. - 🇨🇳 Meanwhile in China, the [HOW2026 Postgres and IvorySQL Conference](https://ivorysql.io/) is taking place April 26-28 in Jinan. - 🇦🇲 Last but not least, registration for [PGDay Armenia](https://pgdayarmenia.com/) opens this week. It takes place in Yerevan on April 30. [How Moving One Word Can Speed Up a Query 10-50x](https://postgres.ai/blog/20260311-not-exists-vs-exists-partial-index) — Two logically equivalent queries (one using `EXISTS ... AND NOT deleted`, the other `NOT EXISTS ... AND deleted`) lead to a 32x difference in performance. It comes down to a difference in how indexes are used, and is the sort of thing that could bite you one day too. Boguk & Samokhvalov (PostgresAI) [Postgres 19's New, Built-In `REPACK`Command](https://www.depesz.com/2026/03/19/waiting-for-postgresql-19-introduce-the-repack-command/) — _"`REPACK` absorbs the functionality of `VACUUM FULL` and `CLUSTER` in a single command. Because this functionality is completely different from regular VACUUM, having it separate makes it easier for users to understand..."_ Hubert, who is very excited about this development, shows us how it works in practice. Hubert Lubaczewski [Waiting For Postgres 19: Allow Table Exclusions in Publications](https://www.depesz.com/2026/03/18/waiting-for-postgresql-19-allow-table-exclusions-in-publications-via-except-table/) — Logical replication publications using `FOR ALL TABLES` will be able to _exclude specific tables_ with a new `EXCEPT TABLE`syntax. Hubert Lubaczewski ▶[Building Postgres Services on Azure with Charles Feddersen](https://talkingpostgres.com/episodes/building-postgres-services-on-azure-with-charles-feddersen) — Charles leads production management for [Postgres on Azure](https://azure.microsoft.com/en-gb/products/postgresql/) at Microsoft and joined Claire Giordano to explain just _what_ Microsoft builds on top of Postgres, why, and how they respect and get involved with the open source community. Talking Postgres podcast 📄 [EXPLAIN's Other Superpowers](http://richyen.com/postgres/2026/03/23/explain_options.html) — A look at commonly overlooked options like `BUFFERS`, `MEMORY` (new in PG18), `WAL`, `SETTINGS`, and `VERBOSE`. Richard Yen 📄 [Debugging RDS Proxy Pinning: How a Hidden JIT Toggle Created Thousands of Pinned Connections](https://richyen.com/postgres/2026/03/12/rds_proxy_pinning.html) Richard Yen 📄 [A Postgres 17 to 18 Upgrade Guide](https://dataegret.com/2026/03/postgresql-major-upgrades-ultimate-guide-in-2026/) Ilya Kosmodemiansky (Data Egret) 📰 Classifieds 📌 [pgedge-postgres-mcp](https://github.com/pgEdge/pgedge-postgres-mcp): an open source bridge between AI assistants & your data with prod-ready performance. --- 👾 A conference for engineers who did the big rewrite - and lived to tell the story. [BugBash](https://antithesis.com/bugbash/conference2026/) 2026, April 23-24, Washington DC. --- Build & share your dev journey using Aiven's free tier to compete for $1,000. Share your project using #AivenFreeTier by March 31. [Enter here](https://fandf.co/4b60Lm0). **TOOLS, RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/vtjthtgfvu2k0dek91vn.jpg)](https://tigerfs.io) [TigerFS: A Filesystem Backed by Postgres](https://tigerfs.io) — A new project out of [Tiger Data](https://www.tigerdata.com/) that provides a FUSE/NFS filesystem where every file is a table row, writes use transactions, and multiple users can read/write concurrently with full ACID guarantees. Designed for agent coordination or any tool that works with files. Tiger Data [pg_jitter 0.2: Alternative JIT Backends for Postgres 14-18](https://github.com/vladich/pg_jitter/releases/tag/v0.2.0) — Brings extra JIT backends to Postgres for faster compilation of queries ([benchmarks here](https://github.com/vladich/pg_jitter?tab=readme-ov-file#benchmarks)). v0.2 adds SIMD acceleration for string and JSON ops, acceleration of regexes and `LIKE`, binary search for `CASE`, Windows support, and more. Vladimir Churyukin [Introducing `pgtui`: A Postgres TUI Client](https://kdwarn.net/programming/blog/227) — A new Rust and Ratatui-powered TUI for doing basic work on Postgres databases. The unique idea is you use your own editor for data entry and edits, with TOML as the interchange format. Kris Warner 🔎 [SlowQL: A SQL Static Analyzer](https://github.com/makroumi/slowql) — An SQL static analyzer that identifies dangerous query patterns before they reach production, offering over 250 rules covering security, performance anti-patterns, and compliance. It works completely offline and includes dialect-aware analysis for Postgres. makroumi - 🕒 [TimescaleDB 2.26.0](https://github.com/timescale/timescaledb/releases/tag/2.26.0) – The popular time-series database extension gets a few key performance improvements. - 🔒 [safesession 0.1](https://github.com/danolivo/safesession) – Extension to lock a session as read-only. Once loaded, every transaction in the session is forced read-only. Targeted at AI agent and automated use cases. - [River 0.32](https://github.com/riverqueue/river/releases/tag/v0.32.0) – High-performance Postgres-powered job processing for Go. - [Knex.js 3.2](https://knexjs.org/) – Powerful SQL query builder for Node.js. - [squawk 2.44.0](https://github.com/sbdchd/squawk/releases/tag/v2.44.0) – Linter for Postgres migrations. - [pg_clickhouse 0.1.5](https://justatheory.com/2026/03/pg_clickhouse-0.1.5/) **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|*).