[8.0.0] out of memory on large UPDATE - Mailing list 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@hub.org           Yahoo!: yscrappy              ICQ: 7615664