Alvaro Herrera <alvhe...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs