Postgres Pro
Downloads
Home   >   mailing lists

Re: plan difference between set-returning function with ROWS within IN() and a plain join - Mailing list pgsql-performance

From Frank van Vugt
Subject Re: plan difference between set-returning function with ROWS within IN() and a plain join
Date
Msg-id 200805061355.52654.ftm.van.vugt@foxi.nl
Whole thread Raw
In response to Re: plan difference between set-returning function with ROWS within IN() and a plain join  (PFC <lists@peufeu.com>)
List pgsql-performance
Tree view 
> > 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.

pgsql-performance by date:

Previous
From: Vlad Arkhipov
Date:
Subject: Seqscan problem
Next
From: Jeff
Date:
Subject: Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline)