quang + postgresql   15

It's a view, it's a table... no, it's a materialized view! - Compose Articles
oblem is that if - for some reason - your predicates don't get pushed down into the VIEWs definition, you end up fetching all the rows that the VIEW in question would fetch without the predicate - then you filter through them. That's quite a penalty and you probably wouldn't use the VIEW in the first place if you knew about that.
postgresql  materialized  views  cache  performance 
june 2018 by quang

Copy this bookmark: