Postgres Pro
Downloads
Home   >   mailing lists

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 22212.1123770971@sss.pgh.pa.us
Whole thread Raw
In response to [8.0.0] out of memory on large UPDATE  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: [8.0.0] out of memory on large UPDATE  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-bugs
Tree view 
"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.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: [8.0.0] out of memory on large UPDATE
Next
From: Richard Huxton
Date:
Subject: Re: BUG #1819: COPY filename rejects Windows format path