Re: slow IN() clause for many cases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: andrew(at)supernews(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: slow IN() clause for many cases
Date: 2005-10-15 21:42:30
Message-ID: 326.1129412550@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <gsstark(at)mit(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-10-15 21:50:26 Re: A costing analysis tool
Previous Message Greg Stark 2005-10-15 21:37:53 Re: slow IN() clause for many cases