Wells Oliver schrieb am 22.06.2018 um 20:51: > Where can I find some more detail? I am deciding between a flat table > populated for the current month only with a script versus a > materialized view, and I'd like to understand better if the latter is > intelligently being refreshed (meaning years of data won't be > re-populated, only what's changed). MViews currently don't support "incremental" refresh in Postgres. A refresh of a mview is essentially the same as: truncate table foo; insert into foo select ... from ....; Where the SELECT part is the query used to define the mview.
