Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedAdvanced PostgreSQL

Refresh Materialized View

The query

SQL

REFRESH MATERIALIZED VIEW CONCURRENTLY monthly_sales_summary;

Tested against PostgreSQL 16

Note

“Updates the stored data in the materialized view. CONCURRENTLY allows reading from the view while it refreshes (requires a unique index on the view).