Re: Problem with very big queries.

Panagiotis Papadakos <papadako@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc