Automatically refresh materialized views in PostgreSQL

" summary

Covers PostgreSQL materialized views (introduced in 9.3) and practical tactics to keep them up-to-date for use cases like real-time dashboards and time-series data. Focuses on how to use and optimize REFRESH MATERIALIZED VIEW — including ways to avoid read-locks, minimize refresh frequency and otherwise make refreshing efficient for different workloads.

AI-written summary · about

" related talks

• 45mpg_ivm - Extensions for Rapid Materialized View UpdateYugo Nagata · PostgreSQL Conference Europe 2024
• 37mContinuous Aggregates A Use Case of Materialized ViewsFabrízio de Royes Mello, Rafia Sabih · PGCon 2023
• 02h 00mTutorialAndres Freund, Marco Slot · PGConf Silicon Valley 2015
• 01h 09mReplacing Oracle Features in PostgreSQL: HA, Functions & ExtensibilityShayon Sanyal · Postgres Conference Orlando 2025
• 24mRevitalizing Outdated Data Models with PostgreSQL ViewsNewvick Lee · POSETTE: An Event for Postgres 2024
• 34mUsing a Materialized View with API Platform?Damien Levallois · API Platform Conference 2023
• 31mMaking Data DanceClark Barrett · RailsConf 2015
• 35mHarnessing the Power of Materialised Views in Cosmos DBOlena Borzenko-Turianska · code.talks 2023