Re: How to kick out automatically stuck in queries

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: 'Kris Jurka' <books(at)ejurka(dot)com>
Cc: "'Pgsql-General(at)Postgresql(dot)Org (E-mail)'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to kick out automatically stuck in queries
Date: 2004-02-02 09:29:09
Message-ID: 001501c3e96f$2d299f50$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bernd Helmle 2004-02-02 09:46:47 Re: Search across multiple sources
Previous Message Kris Jurka 2004-02-02 09:13:46 Re: How to kick out automatically stuck in queries