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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to