[8.0.0] out of memory on large UPDATE

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: [8.0.0] out of memory on large UPDATE
Date: 2005-08-11 13:48:39
Message-ID: 20050811104458.G1002@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.
0.000u 0.022s 2:41:14.76 0.0% 88+66k 12+0io 19pf+0w

And the server is running:

PostgreSQL 8.0.0 on i386-portbld-freebsd4.10, compiled by GCC 2.95.4

I haven't had a chance to upgrade it to 8.0.3 yet ... didn't realize we
had any limits on stuff like this ... bug, or really a limit?

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-08-11 14:36:11 Re: [8.0.0] out of memory on large UPDATE
Previous Message Rafael Barrios 2005-08-11 12:51:51 BUG #1816: Insert null values on a null field