henk de wit wrote:
Hi,
I'm running into a problem with PostgreSQL 8.2.4 (running on 32 bit
Debian Etch/2x dual core C2D/8GB mem). The thing is that I have a
huge transaction that does 2 things: 1) delete about 300.000 rows
from a table with about 15 million rows and 2) do some (heavy)
calculations and re-insert a litlte more than 300.000 new rows.
My problem is that this consumes huge amounts of memory.
What exactly consumes all your memory? I'm assuming it's not just
straight SQL.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
