Blog

Views and Materialized Views in PostgreSQL: Updatable Views, security_invoker, REFRESH CONCURRENTLY and Scheduling with pg_cron

In PostgreSQL a materialized view stores its result on disk and changes only with REFRESH; a plain REFRESH blocks reads, CONCURRENTLY does not but needs a unique index. The SELECT * and column change limits of views, automatically updatable views and WITH CHECK OPTION, what security_invoker changes on a table with RLS, a refresh every 10 minutes with pg_cron, keyless entity mapping in EF Core, and when to use a separate read model table.