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.
I tend to agree with the upthread opinion that if you're on a platform
that responds so ungracefully to memory hogs, you'd be best off using
ulimit to confine backends to a moderate amount of memory space.
But this *is* a platform problem; it's just one more example of how
poorly designed and implemented Linux's memory handling is.
regards, tom lane