When forced to denormalize for performance reasons, how do you ensure data integrity? I like to, instead of denormalizing, use materialized views, which offer lots of the same benefits without the costs. Yet, in Postgres they're only experimental add-ons, not to be relied on for production use.
Is there a timetable for supporting materialized views in Postgres proper? Are other people interested in them (it's #1 on my miss-from-Oracle list)? What other solutions do people use? (Triggers could work well, if they're done right) SRJ
