From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Bob Kruger <bkruger(at)mindspring(dot)com>, PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Auto-timeout on all queries |
Date: | 1999-07-06 03:04:37 |
Message-ID: | 37817245.9518C3FD@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 1999-07-06 03:08:30 | Re: [GENERAL] Stuck in a vacuum. |
Previous Message | Juan Grigera | 1999-07-06 02:33:50 | JoinClauseSelecivity: bad value |