Re: RES: 8.2.4 selects make applications wait indefinitely

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: RES: 8.2.4 selects make applications wait indefinitely
Дата
Msg-id 15958.1192154290@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: RES: 8.2.4 selects make applications wait indefinitely  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы RES: RES: 8.2.4 selects make applications wait indefinitely  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
Re: RES: 8.2.4 selects make applications wait indefinitely  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> On 10/11/07, Carlos H. Reimer <carlos.reimer@opendb.com.br> wrote:
>> It=B4s "<IDLE>" but the "query_start" column is refreshed.

> Then the query runs and finishes and the problem is something to do
> with the delivery of the data.  Not sure after that...

That seems to eliminate the possibility that the problem is on the
server side.  I'd suggest trying to get a stack trace from the client
to figure out what it's doing.

BTW, have you looked into the theory that it's triggered by total
data volume rather than number of columns?  That is, try selecting
all the columns but use LIMIT to reduce the number of rows fetched?

            regards, tom lane

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: RES: 8.2.4 selects make applications wait indefinitely
Следующее
От: "Carlos H. Reimer"
Дата:
Сообщение: RES: RES: 8.2.4 selects make applications wait indefinitely