+1 for incremental materialized views. There are workarounds for emulating it with triggers, though. I have found the following discussion to have helped in a

+1 for incremental materialized views. There are workarounds for emulating it with triggers, though. I have found the following discussion to have helped in a problem I had: https://hashrocket.com/blog/posts/materialized-view-strategies-using-postgresql https://hashrocket.com/blog/posts/materialized-view-strategi...