materialized view

Materialized view allows you to store data physically and auto refresh view periodically. Here’s how to create materialized view in PostgreSQL.