Re: Hungry postmaster

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема Re: Hungry postmaster
Дата
Msg-id 42B18394.000003.31126@mfront7.yandex.ru
обсуждение исходный текст
Ответ на Re: Hungry postmaster  (Ian Harding <harding.ian@gmail.com>)
Ответы Re: Hungry postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>> Are PG admins experienced in determining and killing such zombi-sessions?
>> I mean, may be script or something to do this job exist in nature?
>> > Thanks.
>>
>
>#statement_timeout = 0          # 0 is disabled, in milliseconds
>
>I think if you give this item in postgresql.conf a value, it will kill
>long running queries for you.

Thanks.
Not perfect solution, but much better then nothing.

To be honest, I don't quite understand why PG does 'send' again and again, while
EPIPE seems to be unrecoverable.
Isn't it better to terminate server process?

--
Best regards
Ilja Golshtein

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

Предыдущее
От: Ian Harding
Дата:
Сообщение: Re: Hungry postmaster
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DATATYPE for HEX