Re: How to kick out automatically stuck in queries - Mailing list pgsql-general

From Kris Jurka
Subject Re: How to kick out automatically stuck in queries
Date
Msg-id Pine.LNX.4.33.0402020410200.11786-100000@leary.csoft.net
Whole thread Raw
In response to How to kick out automatically stuck in queries  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: How to kick out automatically stuck in queries  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general

On Mon, 2 Feb 2004, [iso-8859-2] Egy�d Csaba wrote:

> Hi All,
> I'm wonder if there is any possibility to kick out automatically stuck in
> queries after say 10 minutes or so?
> I mean some kind of queries which calls eg. buggy functions with dead loops
> or something similar.
> Time to time I face such kind of problems which are solved automatically
> after some hours/days.
>
> Is there any options in config files or other settings to shorten this time?

See the statement_timeout config parameter.

http://www.postgresql.org/docs/7.3/static/runtime-config.html

Kris Jurka


pgsql-general by date:

Previous
From: Michal Hlavac
Date:
Subject: Array in stored procedure
Next
From: Együd Csaba
Date:
Subject: Re: How to kick out automatically stuck in queries