There’s awesome work being done on incremental view maintenance in postgres:

https://github.com/sraoss/pg_ivm