Re: [PERFORM] Using materialized views for commonly-queried subsets

2006-03-10 Thread Jim C. Nasby
See also http://www.jonathangardner.net/PostgreSQL/materialized_views/matviews.html On Fri, Mar 10, 2006 at 02:25:08AM +, Casey Allen Shobe wrote: > I typed up a description of a situation where the only viable option to > improve performance was to use a materialized view, which, when implem

[PERFORM] Using materialized views for commonly-queried subsets

2006-03-09 Thread Casey Allen Shobe
I typed up a description of a situation where the only viable option to improve performance was to use a materialized view, which, when implemented, was found to improve performance twenty-sevenfold, even with a fairly small amount of excess data (which is antipated to grow). I thought this mig