From: Jim C. Nasby <jnasby@pervasive.com>
To: Peter Newman <Peter.Newman@iop.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: 100% CPU
Date: Fri, 30 Jun 2006 12:58:35 -0500
Message-ID: <20060630175834.GH17241@pervasive.com> (raw)
In-Reply-To: <OF51DC7198.0261E465-ON8025719D.0029227A-8025719D.002986E0@iop.org>
References: <OF51DC7198.0261E465-ON8025719D.0029227A-8025719D.002986E0@iop.org>
moving to -performance
On Fri, Jun 30, 2006 at 08:32:39AM +0100, Peter Newman wrote:
> Good Morning
>
> I am new to postgres and have been asked to look at a server where we
> truncate a table then load data.
>
> The CPU has started to hit 100% usage during this process.
>
> Can you please describe what steps I could take to investigate and solve
> this issue?
> So far all I have done is run a Vacuum Analyze command using PGAdmin
> III.....which appears to have made little difference.
How many indexes do you have on the table? How exactly are you loading
the data? What hardware is this? What version of the database?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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: jnasby@pervasive.com, Peter.Newman@iop.org
Subject: Re: 100% CPU
In-Reply-To: <20060630175834.GH17241@pervasive.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