Ahh! Thanks Kris! That works! -- Csaba > -----Original Message----- > From: Kris Jurka [mailto:[EMAIL PROTECTED] > Sent: 2004. február 2. 10:14 > To: Együd Csaba > Cc: [EMAIL PROTECTED] (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. >
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
