Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on For Want of a JOIN. Parent comment
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).
There are no comments on this comment yet.
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).