Postgres Pro
Downloads
Home   >   mailing lists

Problem with very big queries. - Mailing list pgsql-jdbc

From Panagiotis Papadakos
Subject Problem with very big queries.
Date
Msg-id 200804110152.43906.papadako@csd.uoc.gr
Whole thread Raw
Responses Re: Problem with very big queries.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Problem with very big queries.  (Dave Cramer <davec@fastcrypt.com>)
Re: Problem with very big queries.  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
Tree view 
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.

pgsql-jdbc by date:

Previous
From: Art Gramlich
Date:
Subject: Re: Patch to add a socketTimeout property.
Next
From: Panagiotis Papadakos
Date:
Subject: Re: Problem with very big queries.