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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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