Re: Select where id in (LARGE LIST) ?

Tom Lane wrote:
> 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.

With a really big IN list (16384 triggered it, 8192 didn't) I get
"ERROR: stack depth limit exceeded", though I guess this is more a limit
in the handling of IN than a number-of-parameters limit per se.

-O