By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,386 Members | 1,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,386 IT Pros & Developers. It's quick & easy.

How to kick out automatically stuck in queries

P: n/a
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 Egyd
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a


On Mon, 2 Feb 2004, [iso-8859-2] Egyd 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/s...me-config.html

Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 22 '05 #2

P: n/a
Ahh! Thanks Kris! That works!
-- Csaba
-----Original Message-----
From: Kris Jurka [mailto:bo***@ejurka.com]
Sent: 2004. februr 2. 10:14
To: Egyd Csaba
Cc: Pg***********@Postgresql.Org (E-mail)
Subject: Re: [GENERAL] How to kick out automatically stuck in queries


On Mon, 2 Feb 2004, [iso-8859-2] Egyd 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/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.

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

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.