Hacker News new | ask | show | jobs
by serpix 819 days ago
https://github.com/sraoss/pg_ivm does what you need
1 comments

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.