Re: How to kick out automatically stuck in queries

Ahh! Thanks Kris! That works!
-- Csaba

> -----Original Message-----
> From: Kris Jurka [mailto:books(at)ejurka(dot)com]
> Sent: 2004. február 2. 10:14
> To: Együd Csaba
> Cc: Pgsql-General(at)Postgresql(dot)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.
>