Another nice feature would be a "guesstimate limit". So instead of the
query running a 1/2 hour and then timing out as taking too long, you get
an instant response "Me thinks this query is too hard. Get permission
from your sysadmin to run it".
Kane Tao wrote:
>
> 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.
> >
> >
> >