Slight tangent, but this reminds me of discussions I've seen in the Postgres email servers about native support for real-time materialized views. Does anyone know if we can expect to see something like this in a future version of Postgres?
I don't know about the support in core but there is this extension https://github.com/sraoss/pg_ivm