Morgan Kita wrote:

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

Reply via email to