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 по дате отправления