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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Panagiotis Papadakos 2008-04-10 23:10:37 Re: Problem with very big queries.
Previous Message Panagiotis Papadakos 2008-04-10 22:52:43 Problem with very big queries.