Thread: 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 > -----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 queries > > > > > 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 > > -- 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. >