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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

re: How to kick out automatically stuck in queries

On Mon, 2 Feb 2004, [iso-8859-2] Együd Csaba wrote:
[color=blue]
> 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?[/color]

See the statement_timeout config parameter.

http://www.postgresql.org/docs/7.3/s...me-config.html

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

re: How to kick out automatically stuck in queries

Ahh! Thanks Kris! That works!
-- Csaba
[color=blue]
> -----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:
>[color=green]
> > Hi All,
> > I'm wonder if there is any possibility to kick out[/color]
> automatically stuck in[color=green]
> > queries after say 10 minutes or so?
> > I mean some kind of queries which calls eg. buggy functions[/color]
> with dead loops[color=green]
> > or something similar.
> > Time to time I face such kind of problems which are solved[/color]
> automatically[color=green]
> > after some hours/days.
> >
> > Is there any options in config files or other settings to[/color]
> shorten this time?
>
> See the statement_timeout config parameter.
>
> http://www.postgresql.org/docs/7.3/s...me-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.
>[/color]


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend