Re: Select where id in (LARGE LIST) ?

I know from when I was testing "SELECT ... WHERE id IN (...,...)" I got
a buffer over flow or similar exception from the postgresql native
process at about 200-300 longs in the IN clause. Could do with finding
what the real limits are so I can protect against it. I will have a dig
though the documentation later see what I can find :-)

Thanks

Jasper

Oliver Jowett wrote:

>Jasper Potts wrote:
>
>
>
>>The big question here is whats the max length of a query sent though
>>JDBC to Postgresql???
>>
>>
>
>You'll hit backend limits (I'm not sure if there are any explicit limits
>there other than available memory) before you hit any protocol limits;
>the protocol limits kick in at around 1GB..
>
>-O
>
>