Public list by ~postgresweekly
https://boringsql.com/posts/strong-views/
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…
3 months ago
https://www.tigerdata.com/go/trial
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.
3 months ago
https://richyen.com/postgres/2026/05/11/generated_columns_jsonb.html
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.
3 months ago
https://www.pgedge.com/blog/no-compiler-required-writing-sql-only-postgres-extensions
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.
3 months ago
https://thebuild.com/blog/2026/05/08/a-field-guide-to-alternative-storage-engines-for-postgresql/
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.
3 months ago
https://talkingpostgres.com/episodes/from-memsql-to-horizondb-an-engineers-journey-with-adam-prout
▶  From MemSQL to HorizonDB: An Engineer's Journey with Adam Prout — The founding architect of Azure HorizonDB on his 20-year journey through relational databases to Postgres.
3 months ago
https://dventimisupabase.github.io/pg_flight_recorder/
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.
3 months ago
https://skuznetsov.github.io/pg_sorted_heap/
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.
3 months ago