> Application can tolerate stale data...

Projects like https://readyset.io/, https://materialize.com/, https://github.com/mit-pdos/noria can keep your materialized views up to date as the underlying base tables change.

These look interesting. It's worth mentioning that incremental view maintenance is coming to PostgreSQL. For now that feature (from same contributor) is available as extension https://github.com/sraoss/pg_ivm