I don’t want to be rude, but this is a bad use case for materialized views, and does not provide an adequate technical solution to the problems discussed.

A better, canonical use case for matviews is subdividing the projects table into project-tasks-reporting by month by customer by market vertical, or what have you.

All said, still not a massive needle-mover