I've only used Postgres' and (ages ago) MSSQL's materialized views. What is pg missing compared to the others?
I've found them VERY useful for a narrow range of use cases but, I probably don't realize what I'm missing.