View Single Post

   
  #5 (permalink)  
Old 04-16-2008, 01:00 AM
Panagiotis Papadakos
 
Posts: n/a
Default Re: Problem with very big queries.

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




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

Reply With Quote