Re:How we made data aggregation on PostgreSQL better and faster
by aidos on Tuesday June 21, 2022 @02:50PM
(#31827577)
Interesting. I check back on the wiki page every couple of years to see what progress is being made.
The basic idea seems to be to track the primary keys of the base tables in the incremental view and then use triggers to update those rows when source rows are updated.
The meat of the project is over here for anyone that’s interested - in particular this section about the limitations is pretty interesting (and expected).
https://github.com/sraoss/pg_ivm/#supported-view-definitions...
https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...
https://yugonagata-pgsql.blogspot.com/2022/05/pgivm-v10-rele...