>> 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