On Tue, Feb 14, 2012 at 6:27 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
> A materialized view is actually a table that holds a (possibly
> aggregated)
> copy of data from elsewhere in the database.
>
> Apart from materialized views, you can denormalize for performance by
> adding columns to tables that store a copy of information from another
> table,
> with the benefit that you can avoid joins to access the information.
The standard reference for materialized views is the page by j gardner:
http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views