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 PFC
Subject Re: plan difference between set-returning function with ROWS within IN() and a plain join
Date
Msg-id op.uap8e3owcigqcu@apollo13.peufeu.com
Whole thread Raw
In response to plan difference between set-returning function with ROWS within IN() and a plain join  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
Responses Re: plan difference between set-returning function with ROWS within IN() and a plain join  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
List pgsql-performance
Tree view 
On Tue, 06 May 2008 10:21:43 +0200, Frank van Vugt <ftm.van.vugt@foxi.nl>
wrote:

> L.S.
>
> 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 ?

pgsql-performance by date:

Previous
From: Frank van Vugt
Date:
Subject: plan difference between set-returning function with ROWS within IN() and a plain join
Next
From: Vlad Arkhipov
Date:
Subject: Seqscan problem