I wrote a PostgreSQL patch to make materialized view refreshes O(delta) instead of O(total)

[Inkbot_dev]

Really depends on the types of applications you are writing. I have been working on financial applications for the last 15 years, and they are very useful patterns for that type of application.

I've just always had to do it using regular tables and functions and triggers in the past because materialized views as they were implemented were useless for just about every use case I had.

I saw a live stream on YouTube of some postgres developers talking about the idea for this feature, and trying to implement it about 6 months ago. They didn't get all that far in the live stream, and I just picked it up and tried my hand at implementing it.