X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 606883A3E97 for ; Tue, 4 Jan 2005 18:06:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83809-07 for ; Tue, 4 Jan 2005 18:06:18 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 93A8B3A3F00 for ; Tue, 4 Jan 2005 18:06:18 +0000 (GMT) Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6864756; Tue, 04 Jan 2005 10:07:55 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: query rewrite using materialized views Date: Tue, 4 Jan 2005 10:06:18 -0800 User-Agent: KMail/1.6.2 Cc: Yann Michel References: <20050103165532.GA21212@zoom.spline.inf.fu-berlin.de> In-Reply-To: <20050103165532.GA21212@zoom.spline.inf.fu-berlin.de> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200501041006.18735.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/40 X-Sequence-Number: 9730 Yann, > are there any plans for rewriting queries to preexisting materialized > views? I mean, rewrite a query (within the optimizer) to use a > materialized view instead of the originating table? Automatically, and by default, no. Using the RULES system? Yes, you can already do this and the folks on the MattView project on pgFoundry are working to make it easier. -- Josh Berkus Aglio Database Solutions San Francisco