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.