Panagiotis Papadakos <papadako(at)csd(dot)uoc(dot)gr> writes:
> I am using 8.0.15 postgres server and unfortunately can't upgrade to 8.3
> since I am using sp-gist tries.
How about 8.2?
> So, there is a limit in the allowable query length?
Not per se. Sufficiently complex queries will run out of memory,
of course. 8.2 and up handle long IN lists a bit more efficiently
than prior versions, so you can use longer lists in the same amount
of memory.
regards, tom lane