On Tue, Feb 14, 2012 at 6:27 AM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
