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 601FF3A291E for ; Wed, 5 Jan 2005 08:12:17 +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 03206-03 for ; Wed, 5 Jan 2005 08:11:51 +0000 (GMT) Received: from zong.spline.inf.fu-berlin.de (zong.spline.inf.fu-berlin.de [160.45.117.133]) by svr1.postgresql.org (Postfix) with ESMTP id 7E97D3A2913 for ; Wed, 5 Jan 2005 08:11:49 +0000 (GMT) Received: from zong.spline.inf.fu-berlin.de (localhost [127.0.0.1]) by zong.spline.inf.fu-berlin.de (8.13.1/8.13.1) with ESMTP id j058BhoX012092; Wed, 5 Jan 2005 09:11:43 +0100 Received: (from yann@localhost) by zong.spline.inf.fu-berlin.de (8.13.1/8.13.1/Submit) id j058BfWE012091; Wed, 5 Jan 2005 09:11:41 +0100 Date: Wed, 5 Jan 2005 09:11:41 +0100 From: Yann Michel To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: query rewrite using materialized views Message-ID: <20050105081141.GA12084@zong.spline.inf.fu-berlin.de> References: <20050103165532.GA21212@zoom.spline.inf.fu-berlin.de> <200501041006.18735.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200501041006.18735.josh@agliodbs.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/50 X-Sequence-Number: 9740 Hi, On Tue, Jan 04, 2005 at 10:06:18AM -0800, Josh Berkus wrote: > > 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. I was just wondering if this might be on schedule for 8.x due to I read the thread about materialized views some days ago. If materialized views are someday implemented one should kepp this requested feature in mind due to I know from Oracle to let it improve query execution plans... Regards, Yann