Unconventional Postgres Optimizations — Another fantastic post from Haki Benita. This time, he looks at some optimization techniques off the beaten track, including using constraint_exclusion to skip scans when queries contradict CHECK constraints, building smaller indexes by indexing lower-cardinality expressions (e.g. truncating timestamps to dates), and enforcing uniqueness with hash indexes via exclusion constraints.

Haki Benita

POSETTE 2026 — CFP Closes Feb. 1 — POSETTE: An Event for Postgres, a free & virtual developer event organized by the Postgres team at Microsoft, is happening June 16-18. New and experienced speakers are encouraged to submit! Don’t delay—the CFP closes Feb. 1. Get the details.

Microsoft sponsor

The Challenges of Soft Delete — To delete or not to delete, that is the question! If you want to ‘delete’ data in a table without actually losing it, a ‘soft’ delete using a boolean or date flag is a common solution, but this post considers some alternatives, like using a trigger to move a row to an archive table or capturing deleted rows from the WAL for external archival.

atlas9

🎤 'How I Got Started with DBtune and Why We Chose Postgres' — Luigi Nardi, founder of DBtune and a Stanford researcher, joined Claire Giordano to talk about his developer and research journey, why DBtune chose database tuning and Postgres as their focus, and the concept of ‘level five’ autonomy for database management and tuning. There's a full transcript if you'd rather read than listen.

Talking Postgres Podcast

Scaling Vector Search to 1 Billion on PostgreSQL — 1 billion vectors, specifically. This is essentially a benchmark of VectorChord 1.0, an extension for high-scale vector similarity search (GitHub repo).

Junyu Chen (VectorChord)