Problem with very big queries.

From: Panagiotis Papadakos <papadako(at)csd(dot)uoc(dot)gr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with very big queries.
Date: 2008-04-10 22:52:43
Message-ID: 200804110152.43906.papadako@csd.uoc.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2008-04-10 23:04:42 Re: Problem with very big queries.
Previous Message Art Gramlich 2008-04-10 21:59:07 Re: Patch to add a socketTimeout property.