Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group