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: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
