Re: Big question on insert performance/using COPY FROM

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