Re: statement_timeout is not cancelling query - Mailing list pgsql-bugs

From Robert Haas
Subject Re: statement_timeout is not cancelling query
Date
Msg-id 603c8f070912151027i56f074few50a9adcd524942b@mail.gmail.com
Whole thread Raw
In response to Re: statement_timeout is not cancelling query  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: statement_timeout is not cancelling query
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: statement_timeout is not cancelling query
Next
From: Robert Haas
Date:
Subject: Re: BUG #5242: ODBC driver v8.4.1 crashed