Re: [GENERAL] Auto-timeout on all queries

> >   > 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.
> >
> >   --
> >     Bruce Momjian                        |  http://www.op.net/~candle
> >     maillist@candle.pha.pa.us            |  (610) 853-3000
> >     +  If your life is a hard drive,     |  830 Blythe Avenue
> >     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
> >     19026
>
> I think we'd use it.  At least on our development machines, which have
> occasionally suffered from the ill effects of an excessively ambitious
> query.
>
> How would the interface to the user look?

I assume it would be a new 'SET' option, like "SET TIMEOUT=60", but we
already use alarm() for something else, so it may be more difficult than
I thought.  Not sure.

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