Re: How to kick out automatically stuck in queries
От | Együd Csaba |
---|---|
Тема | Re: How to kick out automatically stuck in queries |
Дата | |
Msg-id | 001501c3e96f$2d299f50$230a0a0a@compaq обсуждение исходный текст |
Ответ на | Re: How to kick out automatically stuck in queries (Kris Jurka <books@ejurka.com>) |
Список | pgsql-general |
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. >
В списке pgsql-general по дате отправления: