Skip site navigation (1) Skip section navigation (2)

Re: Problem with very big queries.

From: Panagiotis Papadakos <papadako(at)csd(dot)uoc(dot)gr>
To: Dave Cramer <davec(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with very big queries.
Date: 2008-04-10 23:10:37
Message-ID: 200804110210.38000.papadako@csd.uoc.gr (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Friday 11 April 2008 02:04:42 Dave Cramer wrote:
> First you should upgrade your server to 8.0.15
>
> The server is segfaulting. The driver is just reporting that the
> server crashed.
Hi!

I am using 8.0.15 postgres server and unfortunately can't upgrade to 8.3
since I am using sp-gist tries. So, there is a limit in the allowable query 
length?

Thanks.

>
> Dave
>
> On 10-Apr-08, at 6:52 PM, Panagiotis Papadakos wrote:
> > Hello everybody.
> >
> > I want to send to postgresql-8.0 a very big query,
> > select * from table where lala IN (....)
> > Inside IN there are almost 60000 values.
> >
> > Unfortunately, the server terminates with a singal 11 and I get
> > to my console the following:
> >
> > An I/O error occured while sending to the backend.
> > An I/O error occured while sending to the backend.
> >
> > jdbc version is  	8.0-322 JDBC 3.
> >
> > Could anybody help?
> >
> > Regards.
> >
> > --
> > Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-jdbc



In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2008-04-10 23:20:51
Subject: Re: Problem with very big queries.
Previous:From: Dave CramerDate: 2008-04-10 23:04:42
Subject: Re: Problem with very big queries.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group