What Is Materialized View?
A materialized view stores the result of a query physically on disk. It can be refreshed periodically and speeds up repeated access to complex joins or aggregations. Unlike regular views, they don’t update in real-time.
Why It Matters for PostgreSQL Performance
In PostgreSQL performance work, Materialized View affects throughput, latency, or operational reliability depending on workload and configuration.
Practical Benchmarking Context
When benchmarking with pgbench, track how Materialized View changes behavior across scale factor, client concurrency, and storage conditions.
Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.
Example
Command: REFRESH MATERIALIZED VIEW view_name;