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

From Panagiotis Papadakos
Subject Re: Problem with very big queries.
Date
Msg-id 200804110227.34229.papadako@csd.uoc.gr
Whole thread Raw
In response to Re: Problem with very big queries.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
On Friday 11 April 2008 02:22:30 Tom Lane wrote:
> 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?
Unfortunately not. I tried to compile even with 8.1 but many headers were
missing....
>
> > 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.