View Single Post

   
  #3 (permalink)  
Old 05-07-2008, 10:18 AM
Frank van Vugt
 
Posts: n/a
Default Re: plan difference between set-returning function with ROWS within IN() and a plain join

> > I'm noticing a difference in planning between a join and an in() clause,
> > before trying to create an independent test-case, I'd like to know if
> > there's
> > an obvious reason why this would be happening:

>
> Is the function STABLE ?


Yep.

For the record, even changing it to immutable doesn't make a difference in
performance here.



--
Best,




Frank.

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply With Quote