Re: [8.0.0] out of memory on large UPDATE

On Thu, 11 Aug 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> The table contains ~10 million rows:
>
>> # time psql -c "UPDATE xa_url SET url = url;" -U pgsql pareto
>> ERROR:  out of memory
>> DETAIL:  Failed on request of size 32.
>
> 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?

Triggers:
     xa_url_domain_b_i_u BEFORE INSERT OR UPDATE ON xa_url FOR EACH ROW EXECUTE PROCEDURE xa_url_domain()

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664