Materialized

How to Use PostgreSQL Materialized Views
How it works. First, specify the view_name after the CREATE MATERIALIZED VIEW clause. Second, add the query that gets data from the underlying tables ...