Re: Hungry postmaster

Поиск
Список
Период
Сортировка
Искать
От
Ilja Golshtein
Тема
Re: Hungry postmaster
Дата
Msg-id
42B18394.000003.31126@mfront7.yandex.ru
Ответ на
Re: Hungry postmaster (Ian Harding)
Список
Дерево обсуждения
Hungry postmaster "Ilja Golshtein" <ilejn@yandex.ru>
Re: Hungry postmaster Tom Lane <tgl@sss.pgh.pa.us>
Re: Hungry postmaster "Ilja Golshtein" <ilejn@yandex.ru>
Re: Hungry postmaster Ian Harding <harding.ian@gmail.com>
Re: Hungry postmaster "Ilja Golshtein" <ilejn@yandex.ru>
Re: Hungry postmaster Tom Lane <tgl@sss.pgh.pa.us>
Re: Hungry postmaster Martijn van Oosterhout <kleptog@svana.org>
>> 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
FAQ