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 2CF969DC80C for ; Fri, 10 Mar 2006 11:17:37 -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 86526-01 for ; Fri, 10 Mar 2006 11:17:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id DE3129DC821 for ; Fri, 10 Mar 2006 11:17:33 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 0CE6F5645D; Fri, 10 Mar 2006 09:17:39 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Fri, 10 Mar 2006 09:17:37 -0600 Date: Fri, 10 Mar 2006 09:17:37 -0600 From: "Jim C. Nasby" To: Casey Allen Shobe Cc: pgsql-performance@postgresql.org Subject: Re: Using materialized views for commonly-queried subsets Message-ID: <20060310151737.GF45250@pervasive.com> References: <200603100225.08152.lists@seattleserver.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200603100225.08152.lists@seattleserver.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060310:lists@seattleserver.com::Sw9ObpQNPwZEL83U:00000000000000 000000000000000000000000GZz9 X-Hashcash: 1:20:060310:pgsql-performance@postgresql.org::iyH5+lHPL2muxela:00000 0000000000000000000000006L/4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200603/130 X-Sequence-Number: 17567 See also http://www.jonathangardner.net/PostgreSQL/materialized_views/matviews.html On Fri, Mar 10, 2006 at 02:25:08AM +0000, 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 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461