Re: [8.0.0] out of memory on large UPDATE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [8.0.0] out of memory on large UPDATE
Date: 2005-08-11 14:36:11
Message-ID: 22212.1123770971@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Marc G. Fournier" <scrappy(at)postgresql(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2005-08-11 14:43:45 Re: BUG #1819: COPY filename rejects Windows format path
Previous Message Marc G. Fournier 2005-08-11 13:48:39 [8.0.0] out of memory on large UPDATE