[amirouche]

Read the whole textbook, MATERIALIZED VIEW requires a REFRESH that is outside the transaction that made the change: https://www.postgresql.org/docs/current/rules-materializedvi...

[apavlo]

Postgres is not every system. Just because it requires manually refreshing matviews doesn't mean that every DBMS works that way.

Seriously, read a textbook:

http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views....

[amirouche]

Indeed, I jumped into PostgreSQL documentation, that's where I started reading about materialized views.

[amirouche]

I do not think that PDF is worth taking space in my personal knowledge base. Thanks for sharing.