Re: Select where id in (LARGE LIST) ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Jasper Potts <jasper(at)jasperpotts(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Select where id in (LARGE LIST) ?
Date: 2005-08-03 02:39:36
Message-ID: 26493.1123036776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Oliver Jowett <oliver(at)opencloud(dot)com> writes:
> There may be a (backend) limit on the number of parameters in a query,
> not sure.

I'm pretty certain there's no hard limit. However, I doubt anyone has
tested with thousands of parameters ... there might well be performance
issues, such as loops that are O(N^2) in the number of parameters.
Feel free to send along problem cases.

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-08-03 03:13:42 Re: Select where id in (LARGE LIST) ?
Previous Message Oliver Jowett 2005-08-02 23:55:23 Re: some improve JDBC