From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | kdebisschop(at)range(dot)infoplease(dot)com |
Cc: | bkruger(at)mindspring(dot)com, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Auto-timeout on all queries |
Date: | 1999-07-06 18:56:16 |
Message-ID: | 199907061856.OAA18596@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > > 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(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
>
> 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Boliasov Yuri | 1999-07-06 20:19:58 | |
Previous Message | Karl DeBisschop | 1999-07-06 18:35:19 | Re: [GENERAL] Auto-timeout on all queries |