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...

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

Vadim