pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Whats the limit on the number of elements in the IN clause of SELECT/UPDATE/DELETE
2+ messages / 2 participants
[nested] [flat]

* Whats the limit on the number of elements in the IN clause of SELECT/UPDATE/DELETE
@ 2005-03-22 16:22  Gourish Singbal <gourish@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Gourish Singbal @ 2005-03-22 16:22 UTC (permalink / raw)
  To: pgsql-admin

Can some one give me the details for the below  question?.

Whats the limit on the number of elements in the IN clause of
SELECT/UPDATE/DELETE?.


-- 
Best,
Gourish Singbal



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Whats the limit on the number of elements in the IN clause of SELECT/UPDATE/DELETE
@ 2005-03-22 17:50  Bruno Wolff III <bruno@wolff.to>
  parent: Gourish Singbal <gourish@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruno Wolff III @ 2005-03-22 17:50 UTC (permalink / raw)
  To: Gourish Singbal <gourish@gmail.com>; +Cc: pgsql-admin

On Tue, Mar 22, 2005 at 21:52:35 +0530,
  Gourish Singbal <gourish@gmail.com> wrote:
> Can some one give me the details for the below  question?.
> 
> Whats the limit on the number of elements in the IN clause of
> SELECT/UPDATE/DELETE?.

I believe I have seen reports of people using thousands. However, since
this case is converted to OR, it won't be particular fast when you have
a number of values. In that case you are going to be better off loading
them into a temp table, analyzing the table and then using IN with a
subselect (and you want to be using 7.4 or later).



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-03-22 17:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-22 16:22 Whats the limit on the number of elements in the IN clause of SELECT/UPDATE/DELETE Gourish Singbal <gourish@gmail.com>
2005-03-22 17:50 ` Bruno Wolff III <bruno@wolff.to>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox