materialized view

Also written: REFRESH MATERIALIZED VIEW

A view whose query results are stored like a table, so reads are fast but stale until you REFRESH MATERIALIZED VIEW.