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

Re: Problem with very big queries.

From: Dave Cramer <davec(at)fastcrypt(dot)com>
To: Panagiotis Papadakos <papadako(at)csd(dot)uoc(dot)gr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with very big queries.
Date: 2008-04-10 23:04:42
Message-ID: 18DA2AE0-0769-4AD3-879A-D0B1B454BCBD@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
First you should upgrade your server to 8.0.15

The server is segfaulting. The driver is just reporting that the  
server crashed.

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: Panagiotis PapadakosDate: 2008-04-10 23:10:37
Subject: Re: Problem with very big queries.
Previous:From: Panagiotis PapadakosDate: 2008-04-10 22:52:43
Subject: Problem with very big queries.

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