Normalizing denormalization with materialized views

Started by Robert Jamesabout 18 years ago1 messagesgeneral
Jump to latest
#1Robert James
srobertjames@gmail.com

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