For Want of a JOIN

Re:For Want of a JOIN by mnahkies on Thursday December 22, 2022 @01:15PM (#34096494)

I think it's being worked on for postgres but probably another major release or two away, quick Google came up with this https://pgconf.ru/en/2021/288667 but I'm sure I've come across discussion in postgres mailing lists / wiki in the past.

Would definitely be a nice feature to have, without it I find the main use case I have for materialised views is batch processing where you want to prepare a complex result set and then stream process it in a Cronjob or similar

[ Parent | on HN ]

Re:For Want of a JOIN by aidos on Thursday December 22, 2022 @01:55PM (#34096980)

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

[ Parent | on HN ]