How to kick out automatically stuck in queries

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: How to kick out automatically stuck in queries
Date: 2004-02-02 08:29:44
Message-ID: 000701c3e966$b6c64910$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michal Hlavac 2004-02-02 08:37:39 Array in stored procedure
Previous Message Tom Lane 2004-02-02 07:31:28 Re: pg_generate_sequence and info_schema patch (Was: SELECT Question)