Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql-server/src/backend/commands explain.c - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql-server/src/backend/commands explain.c
Date
Msg-id 18529.1044926196@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql-server/src/backend/commands explain.c  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: pgsql-server/src/backend/commands explain.c  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-committers
Tree view 
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Out of interest Tom, did you optimise the IN (huge list of scalars) case, or
> is it just the IN (subselect) case?

Just IN (subselect).  AFAIK, IN (list of scalars) works reasonably well
already... at least for cases where the lefthand side is an indexed
column.  What problems are you concerned about?

            regards, tom lane

pgsql-committers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql-server/src/backend/commands explain.c
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql-server/src/backend/commands explain.c