Re: Hungry postmaster - Mailing list pgsql-general

From Ian Harding
Subject Re: Hungry postmaster
Date
Msg-id 7256023005061606352311acf4@mail.gmail.com
Whole thread Raw
In response to Re: Hungry postmaster  ("Ilja Golshtein" <ilejn@yandex.ru>)
Responses Re: Hungry postmaster  ("Ilja Golshtein" <ilejn@yandex.ru>)
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.

> --
> Best regards
> Ilja Golshtein
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

pgsql-general by date:

Previous
From: "Ilja Golshtein"
Date:
Subject: Re: Hungry postmaster
Next
From: "Ilja Golshtein"
Date:
Subject: Re: Hungry postmaster