Re: Hungry postmaster - Mailing list pgsql-general

From Ilja Golshtein
Subject Re: Hungry postmaster
Date
Msg-id 42B18394.000003.31126@mfront7.yandex.ru
Whole thread Raw
In response to Re: Hungry postmaster  (Ian Harding <harding.ian@gmail.com>)
Responses Re: Hungry postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Ian Harding
Date:
Subject: Re: Hungry postmaster
Next
From: Tom Lane
Date:
Subject: Re: DATATYPE for HEX