What does HackerNews think of pg_ivm?

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

Language: C

Lesser Known Postgres Features (2021) | Aug 2023
This is being worked on if I recall:

https://github.com/sraoss/pg_ivm

PostgreSQL 16 Beta 1 | May 2023
Postgresql is amazing but I must say the last few updates have been a bit disappointing.

Still waiting for automatic incremental updates for materialized views - been worked on for several years but still not released!

https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc...

https://github.com/sraoss/pg_ivm

Features I'd Like in PostgreSQL | Jan 2023
Expand Context ↕
Maybe https://github.com/sraoss/pg_ivm might be of help?
Materialized View: SQL Queries on Steroids | Jan 2023
There’s awesome work being done on incremental view maintenance in postgres:

https://github.com/sraoss/pg_ivm

Materialized View: SQL Queries on Steroids | Jan 2023
Expand Context ↕
These look interesting. It's worth mentioning that incremental view maintenance is coming to PostgreSQL. For now that feature (from same contributor) is available as extension https://github.com/sraoss/pg_ivm
The next generation of Materialize | Oct 2022
Expand Context ↕
You might be interested in https://github.com/sraoss/pg_ivm
The data rules worth $40k a day | Jul 2022
Expand Context ↕
> It’s only significant weakness now is in Materialized views, with their lack of incremental refresh.

> That work towards incrementally updated views is happening and progressing. For now, it's a separate extension, though: https://github.com/sraoss/pg_ivm.

https://news.ycombinator.com/item?id=32098603
PostgreSQL views and materialized views and how they influenced TimescaleDB | Jul 2022
Expand Context ↕
That work towards incrementally updated views is happening and progressing. For now, it's a separate extension, though: https://github.com/sraoss/pg_ivm.
How we made data aggregation on PostgreSQL better and faster | Jun 2022
Expand Context ↕
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...