Re: statement_timeout is not cancelling query

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: statement_timeout is not cancelling query
Дата
Msg-id 603c8f070912151027i56f074few50a9adcd524942b@mail.gmail.com
обсуждение исходный текст
Ответ на Re: statement_timeout is not cancelling query  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: statement_timeout is not cancelling query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Tue, Dec 15, 2009 at 1:23 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> If we're to do anything about this, it is spilling the trigger queue so
>> it doesn't eat an unbounded amount of memory.
>
> Of course, the reason nothing much has been done about that is that
> by the time your trigger queue is long enough to cause such an issue,
> you're screwed anyway --- actually executing all those triggers would
> take longer than you'll want to wait.

What is the best way to go about doing that, anyway?

...Robert

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: statement_timeout is not cancelling query
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #5242: ODBC driver v8.4.1 crashed