X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 45BCD9DC807
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu,  9 Mar 2006 22:28:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 37716-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu,  9 Mar 2006 22:28:12 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from akranes.seattleserver.com (akranes.seattleserver.com
	[205.234.78.154])
	by postgresql.org (Postfix) with ESMTP id 01AED9DC870
	for <pgsql-performance@postgresql.org>;
	Thu,  9 Mar 2006 22:28:06 -0400 (AST)
Received: from pool-71-113-119-162.sttlwa.dsl-w.verizon.net ([71.113.119.162]
	helo=[192.168.0.100])
	by akranes.seattleserver.com with esmtpa (Exim 4.54)
	id 1FHXM2-0007wL-Kl
	for pgsql-performance@postgresql.org; Fri, 10 Mar 2006 02:27:46 +0000
From: Casey Allen Shobe <lists@seattleserver.com>
Organization: SeattleServer.com, Inc.
To: pgsql-performance@postgresql.org
Subject: Using materialized views for commonly-queried subsets
Date: Fri, 10 Mar 2006 02:25:08 +0000
User-Agent: KMail/1.9.1
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200603100225.08152.lists@seattleserver.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.672 required=5 tests=[AWL=0.672]
X-Spam-Score: 0.672
X-Spam-Level: 
X-Archive-Number: 200603/105
X-Sequence-Number: 17542

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 might be 
of use to anybody else in a similar situation, so I thought I'd post it here.

http://community.seattleserver.com/viewtopic.php?t=11

Feel free to reproduce as you see fit.

Cheers,
-- 
Casey Allen Shobe | cshobe@seattleserver.com | 206-381-2800
SeattleServer.com, Inc. | http://www.seattleserver.com