Postgres Pro
Downloads
Home   >   mailing lists

[8.0.0] out of memory on large UPDATE - Mailing list pgsql-bugs

From Marc G. Fournier
Subject [8.0.0] out of memory on large UPDATE
Date
Msg-id 20050811104458.G1002@ganymede.hub.org
Whole thread Raw
Responses Re: [8.0.0] out of memory on large UPDATE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Aaron Harsh"
Date:
Subject: Re: BUG #1800: "unexpected chunk number" during pg_dump
Next
From: Tom Lane
Date:
Subject: Re: [8.0.0] out of memory on large UPDATE