How to kick out automatically stuck in queries
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?
I'm interested in limiting "dead" connections too. I mean frozen client
programs which leave the connection open.
(Server. RH 7.1, PG7.3.2 ; Client: Win98/ME/XP/2k)
Thank you,
-- Csaba Egy�d
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
Ahh! Thanks Kris! That works!
-- Csaba
Show quoted text
-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.com]
Sent: 2004. febru�r 2. 10:14
To: Egy�d Csaba
Cc: Pgsql-General@Postgresql.Org (E-mail)
Subject: Re: [GENERAL] How to kick out automatically stuck in queriesOn Mon, 2 Feb 2004, [iso-8859-2] Egy�d Csaba wrote:
Hi All,
I'm wonder if there is any possibility to kick outautomatically stuck in
queries after say 10 minutes or so?
I mean some kind of queries which calls eg. buggy functionswith dead loops
or something similar.
Time to time I face such kind of problems which are solvedautomatically
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
-- Incoming mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.211 / Virus Database: 261 - Release Date: 2004. 01. 30.