Re: Hungry postmaster

From: Ian Harding <harding(dot)ian(at)gmail(dot)com>
To: ilejn(at)yandex(dot)ru
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-general(at)postgresql(dot)org
Subject: Re: Hungry postmaster
Date: 2005-06-16 13:35:33
Message-ID: 7256023005061606352311acf4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2005-06-16 13:47:24 Re: Autovacuum in the backend
Previous Message Ilja Golshtein 2005-06-16 13:21:35 Re: Hungry postmaster