Re: Premature view materialization in 8.2? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Premature view materialization in 8.2?
Date
Msg-id 15399.1175882434@sss.pgh.pa.us
Whole thread Raw
In response to Re: Premature view materialization in 8.2?  ("Jonathan Ellis" <jonathan@utahpython.org>)
Responses Re: Premature view materialization in 8.2?  ("Jonathan Ellis" <jonathan@utahpython.org>)
List pgsql-performance
"Jonathan Ellis" <jonathan@utahpython.org> 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

pgsql-performance by date:

Previous
From: "Jonathan Ellis"
Date:
Subject: Re: Premature view materialization in 8.2?
Next
From: "Jonathan Ellis"
Date:
Subject: Re: Premature view materialization in 8.2?