Re: OR or IN ?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: Luca Ferrari <fluca1978(at)infinito(dot)it>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: OR or IN ?
Date: 2008-10-17 14:06:04
Message-ID: C51DF7EC.A6115%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Older versions of PG were inefficient with larger numbers of elements in an
IN query, and in fact would error out with something about lack of stack
space if you used very many (a few hundred IIRC).

8.x something was supposed to have improved that. Using 8.3 recently, after
an "oopsie" with some development data, I inadvertently confirmed that it
works and performance is not too bad with >34,000 items in an IN clause ;-)

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

  • OR or IN ? at 2008-10-14 06:33:21 from Luca Ferrari

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Armbrust 2008-10-17 14:11:40 Re: Drop database / database in use question
Previous Message Andrew Sullivan 2008-10-17 13:43:35 Re: Annoying Reply-To