Don't pretend your Postgres views are tables (opens in new tab)

#​648 — May 13, 2026 Web Version Postgres Weekly 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....