Re: [GENERAL] Auto-timeout on all queries

Been thinking about this time thing...wouldn't it be more flexible and more
useful to do it by transaction rather than a global server setting?  Plus
time is a particularly bad measure as loaded servers take longer to execute
queries etc...

-----Original Message-----
From: Peter Eisentraut <peter@pathwaynet.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: Bob Kruger <bkruger@mindspring.com>; PostgreSQL-general
<pgsql-general@postgreSQL.org>
Date: Tuesday, July 06, 1999 5:26 PM
Subject: Re: [GENERAL] Auto-timeout on all queries


>On Mon, 5 Jul 1999, Bruce Momjian wrote:
>
>> > I would like to make one small request for future releases.  Is there a
>> > setup parameter that could be enabled that would put a timeout for a
query
>> > that runs too long or endangers the integrity of the system?  With the
>> > systems that I use, there are times that queries are entered that
contain
>> > errors or run so long that they eventually cause a system crash.  It
would
>> > be most helpful if a timeout limit on queries could be enabled that
would
>> > stop a query after so much time and release the resources back to the
system.
>>
>> Does anyone thing this would be a nice feature?  We can easily do it
>> with alarm()/elog(), but I want to know if it would be valuable.
>
>Oh yeah!
>
>Time out in minutes, "time" out in tuples, all with an instructive error
>message if exceeded. How about
>
>SET TIMEOUT '5 min';
>SET TUPLE LIMIT 10000;
>
>If you can really "easily" do it, I say go for it.
>
>--
>Peter Eisentraut
>PathWay Computing, Inc.
>
>
>