3 ms·

I think this is what you're looking for: https://wiki.postgresql.org/wiki/Incremental_View_Maintenance https://wiki.postgresql.org/wiki/Incremental_View_Mainte

• aidos 4y ago
  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-and-restriction https://github.com/sraoss/pg_ivm/#supported-view-definitions...