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 — We featured Robert Haas's explainer recently, but Hubert goes further with examples using his explain.depesz.com dataset, showing how this new module lets you capture, replay, and override key planner decisions.

Hubert Lubaczewski

Security Gateway for Postgres – Inspect Queries and Results — 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

How Moving One Word Can Speed Up a Query 10-50x — 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 — "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 — Logical replication publications using FOR ALL TABLES will be able to exclude specific tables with a new EXCEPT TABLE syntax.

Hubert Lubaczewski

TigerFS: A Filesystem Backed by Postgres — A new project out of Tiger Data 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 — Brings extra JIT backends to Postgres for faster compilation of queries (benchmarks here). 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 — 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 — 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