Postgres Pro
Downloads
Home   >   mailing lists

Re: Select where id in (LARGE LIST) ? - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Select where id in (LARGE LIST) ?
Date
Msg-id 26493.1123036776@sss.pgh.pa.us
Whole thread Raw
In response to Re: Select where id in (LARGE LIST) ?  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Select where id in (LARGE LIST) ?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tree view 
Oliver Jowett <oliver@opencloud.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

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: some improve JDBC
Next
From: Oliver Jowett
Date:
Subject: Re: Select where id in (LARGE LIST) ?