Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

There’s also info on this page about it (incremental materialised views).

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).



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: