Re:Postgres is eating the database world
by serpix on Friday March 15, 2024 @02:20AM
(#39712562)
https://github.com/sraoss/pg_ivm does what you need
[ Parent
| on HN ]
Re:Postgres is eating the database world
by pgwhalen on Wednesday March 20, 2024 @03:44PM
(#39771162)
pg_ivm has a ton of restrictions though (as do other PG incremental view refresh mechanisms, like timescale hypertables).
That's why I assume it's not in vanilla postgres: adding the future with so many caveats would not make for a great experience for the full breadth of postgres users.