Re: [8.0.0] out of memory on large UPDATE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [8.0.0] out of memory on large UPDATE
Date
Msg-id 23591.1123781243@sss.pgh.pa.us
Whole thread Raw
In response to Re: [8.0.0] out of memory on large UPDATE  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-bugs
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> On Thu, 11 Aug 2005, Tom Lane wrote:
>> If you've got any AFTER UPDATE triggers on that table, you could be
>> running out of memory for the pending-triggers list.

> Nope, only have a BEFORE UPDATE, or would that be similar except for at
> which point it runs out of memory?

Nope, BEFORE UPDATE shouldn't result in any permanent memory
accumulation.

An out-of-memory error should result in a long report in the postmaster
log about how many bytes in each memory context --- can you post that?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [8.0.0] out of memory on large UPDATE
Next
From: Tom Lane
Date:
Subject: Re: [8.0.0] out of memory on large UPDATE