Re: [GENERAL] Auto-timeout on all queries

> 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.
>
> Not so easy - we use SIGALRM in locking...

Oh. :-) I forgot.

>
> But why not just use CANCEL to stop too long running queries?

Good question.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026