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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/src/backend/commands explain.c
Date: 2003-02-11 01:16:36
Message-ID: 18529.1044926196@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-02-11 01:22:37 Re: pgsql-server/src/backend/commands explain.c
Previous Message Christopher Kings-Lynne 2003-02-11 01:03:59 Re: pgsql-server/src/backend/commands explain.c