Morgan Kita wrote:
Hi,
I am currently trying to speed up the insertion of bulk loads to my
database. I have fiddled with all of the parameters that I have seen
suggested(aka checkpoint_segments, checkpoint_timeout,
maintinence_work_mem, and shared buffers) with no success. I even
turned off fysnc with no effect so I am pretty sure the biggest
problem is that the DB is CPU limited at the moment because of the
rather weak machine that postmaster is running on(Athlon 2400+ xp
with 512 RAM)
Don't be pretty sure, be abolutely sure. What do your various
system-load figures show? Windows has a system performance monitoring
tool that can show CPU/Memory/Disk IO, and *nix tools have vmstat or iostat.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
