Postgres Pro
Downloads
Home   >   mailing lists

Re: slow IN() clause for many cases - Mailing list pgsql-hackers

From Tom Lane
Subject Re: slow IN() clause for many cases
Date
Msg-id 326.1129412550@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow IN() clause for many cases  (Greg Stark <gsstark@mit.edu>)
Responses Re: slow IN() clause for many cases
List pgsql-hackers
Tree view 
Greg Stark <gsstark@mit.edu> writes:
> I would fear queries like

>  SELECT * from tab WHERE x IN (1,2,3) LIMIT 1

> Which ought to be instantaneous would become potentially slow.

Why?  They certainly wouldn't be any slower than they are now.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: slow IN() clause for many cases
Next
From: Greg Stark
Date:
Subject: Re: A costing analysis tool