From: Richard Huxton <dev@archonet.com>
To: Morgan Kita <mkita@verseon.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Big question on insert performance/using COPY FROM
Date: Thu, 01 Sep 2005 11:45:25 +0100
Message-ID: <4316DBC5.8060504@archonet.com> (raw)
In-Reply-To: <08B420FF5BF7BC42A064212C2EB768801C10BE@neutron.verseon.com>
References: <08B420FF5BF7BC42A064212C2EB768801C10BE@neutron.verseon.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, mkita@verseon.com
Subject: Re: Big question on insert performance/using COPY FROM
In-Reply-To: <4316DBC5.8060504@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox