Re: Premature view materialization in 8.2?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jonathan Ellis" <jonathan(at)utahpython(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Premature view materialization in 8.2?
Date: 2007-04-06 18:00:34
Message-ID: 15399.1175882434@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jonathan Ellis" <jonathan(at)utahpython(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jonathan Ellis 2007-04-06 18:03:50 Re: Premature view materialization in 8.2?
Previous Message Jonathan Ellis 2007-04-06 17:57:27 Re: Premature view materialization in 8.2?