Materialized views

Materialized views (MV) are views that persist the results of their underlying query, can be refreshed periodically and let you add indexes on them. They're useful when you want to speed up an expensive query and you're ok working with stale data.

There are two ways to refresh a MV:

1. Blocking - which completes faster, but blocks all clients from querying the MV;
2. Concurrently - which completes slower, but lets clients query the MV, although their queries take longer to run. This option works only if the MV has a unique index.

E.g. Naming convention: [app]_vw_[mv_name]_materialized