top | item 31637501 (no title) amirouche | 3 years ago 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... discuss order hn newest apavlo|3 years ago 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|3 years ago Indeed, I jumped into PostgreSQL documentation, that's where I started reading about materialized views. amirouche|3 years ago I do not think that PDF is worth taking space in my personal knowledge base. Thanks for sharing.
apavlo|3 years ago 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|3 years ago Indeed, I jumped into PostgreSQL documentation, that's where I started reading about materialized views. amirouche|3 years ago I do not think that PDF is worth taking space in my personal knowledge base. Thanks for sharing.
amirouche|3 years ago Indeed, I jumped into PostgreSQL documentation, that's where I started reading about materialized views.
amirouche|3 years ago I do not think that PDF is worth taking space in my personal knowledge base. Thanks for sharing.
apavlo|3 years ago
Seriously, read a textbook:
http://db.cs.duke.edu/papers/fntdb12-ChirkovaYang-mat_views....
amirouche|3 years ago
amirouche|3 years ago