Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BEEC19FB565 for ; Fri, 6 Apr 2007 15:00:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 49148-08 for ; Fri, 6 Apr 2007 15:00:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 589A19FB514 for ; Fri, 6 Apr 2007 15:00:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l36I0Yj0015400; Fri, 6 Apr 2007 14:00:34 -0400 (EDT) To: "Jonathan Ellis" cc: pgsql-performance@postgresql.org Subject: Re: Premature view materialization in 8.2? In-reply-to: References: <28349.1175838196@sss.pgh.pa.us> <261.1175840636@sss.pgh.pa.us> <15092.1175881227@sss.pgh.pa.us> Comments: In-reply-to "Jonathan Ellis" message dated "Fri, 06 Apr 2007 11:57:27 -0600" Date: Fri, 06 Apr 2007 14:00:34 -0400 Message-ID: <15399.1175882434@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/172 X-Sequence-Number: 24049 "Jonathan Ellis" writes: > I can do that... you don't think the fact I mentioned, that > redefining the view to leave out the expensive function fixes the > problem, is relevant? Hm, I'd not have thought that an expensive function would get evaluated partway up the join tree, but maybe that's wrong. You never did show us the actual view definition ... regards, tom lane