I think a missing piece is making materialized views fast since there will always be cases where someone wants to denormalize to get around performance issues,

I think a missing piece is making materialized views fast since there will always be cases where someone wants to denormalize to get around performance issues, even with well designed indexes.