| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Morgan Kita <mkita(at)verseon(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Big question on insert performance/using COPY FROM |
| Date: | 2005-09-01 10:45:25 |
| Message-ID: | 4316DBC5.8060504@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulrich Wisser | 2005-09-01 13:25:37 | Need for speed 3 |
| Previous Message | Tobias Brox | 2005-08-31 19:33:17 | Re: Swapping |