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