Strong Views on Postgres VIEWs — Why views are clean to use but painful to change in Postgres, with a tour of how they work under the hood and what’s missing from ALTER VIEW. Surprisingly, the mechanism that would fix it already exists inside pg_dump…

Radim Marek

REFRESH MATERIALIZED VIEW Shouldn't Block Prod — You wrote the materialized view to pre-compute rollups. Now it locks the table on refresh. Get $1000 in credit to try what replaces it. TimescaleDB continuous aggregates update incrementally on live data. No REFRESH, no lock, no cron.

Tiger Data (creators of TimescaleDB) sponsor

Making JSONB More Queryable with Generated Columns — A benchmark-driven comparison of GIN, expression indexes, and generated columns. Richard finds the B-tree-based options beat GIN on query latency, storage, and writes, with generated columns the most maintainable.

Richard Yen

No Compiler Required: Writing SQL-Only Extensions — It’s easy to think of Postgres extensions as complex multi-language projects (many of the most popular ones are!) but they can be built entirely from SQL you already know. Shaun walks through creating such an extension here.

Shaun Thomas

A Field Guide to Alternative Storage Engines for Postgres — Six years after the table access method API shipped in Postgres 12, Christophe surveys what the ecosystem actually looks like and why it’s messier than the early predictions suggested.

Christophe Pettus

pg_flight_recorder: Continuous State Sampling via pg_cron — A pure SQL extension that uses pg_cron to continuously snapshot Postgres state (pg_stat_activity, pg_stat_statements, pg_locks, etc.) to give you access to a rolling history of what was happening when things went wrong.

Dmitry Ventin (Supabase)

pg_sorted_heap 0.13.0: Physically Sorted Storage with HNSW Vector Search — An early-stage extension offering physically sorted tables with zone-map block pruning and a planner-integrated HNSW vector index, no pgvector required. Aimed at GraphRAG and vector retrieval workloads.

Sergey Kuznetsov