Postgres materialized views are pretty terrible / useless compared to other rdbms. I’ve never found a usecase for the very limited pg version.
I've found them VERY useful for a narrow range of use cases but, I probably don't realize what I'm missing.