Problem with very big queries.

Поиск
Список
Период
Сортировка
От Panagiotis Papadakos
Тема Problem with very big queries.
Дата
Msg-id 200804110152.43906.papadako@csd.uoc.gr
обсуждение исходный текст
Ответы 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>)
Список 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.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Art Gramlich
Дата:
Сообщение: Re: Patch to add a socketTimeout property.
Следующее
От: Panagiotis Papadakos
Дата:
Сообщение: Re: Problem with very big queries.