Re: Problem with very big queries. - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Problem with very big queries.
Date
Msg-id 25478.1207869750@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with very big queries.  (Panagiotis Papadakos <papadako@csd.uoc.gr>)
Responses Re: Problem with very big queries.  (Panagiotis Papadakos <papadako@csd.uoc.gr>)
List pgsql-jdbc
Panagiotis Papadakos <papadako@csd.uoc.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

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with very big queries.
Next
From: Panagiotis Papadakos
Date:
Subject: Re: Problem with very big queries.