Materialized views are fundamentally just some syntactical sugar over the results of a query cached in a table. The syntactical sugar does have advantages, but

Materialized views are fundamentally just some syntactical sugar over the results of a query cached in a table. The syntactical sugar does have advantages, but comes at a cost of flexibility - if you need more control over the update process or modification of the data than a full refresh, then you should just use a table (create table whatever as select * from ...).