https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
In the meantime my preferred technique is to have a column where I stamp the last generation time for each row and then I rebuild anything that’s changed since then (assuming all your source data has some sort of last updated stamp).
https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
In the meantime my preferred technique is to have a column where I stamp the last generation time for each row and then I rebuild anything that’s changed since then (assuming all your source data has some sort of last updated stamp).