Auto-timeout on all queries
От | Bruce Momjian |
---|---|
Тема | Auto-timeout on all queries |
Дата | |
Msg-id | 199907060119.VAA10888@candle.pha.pa.us обсуждение исходный текст |
Ответы |
Re: [GENERAL] Auto-timeout on all queries
Re: [GENERAL] Auto-timeout on all queries |
Список | 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@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
В списке pgsql-general по дате отправления: