Thread: 100% CPU

100% CPU

From
Peter Newman
Date:
<br /><font face="sans-serif" size="2">Good Morning</font><br /><br /><font face="sans-serif" size="2">I am new to
postgresand have been asked to look at a server where we truncate a table then load data.</font><br /><br /><font
face="sans-serif"size="2">The CPU has started to hit 100% usage during this process.</font><br /><br /><font
face="sans-serif"size="2">Can you please describe what steps I could take to investigate and solve this
issue?</font><br/><font face="sans-serif" size="2"> So far all I have done is run a Vacuum Analyze command using
PGAdminIII.....which appears to have made little difference.</font><br /><br /><br /><font face="sans-serif"
size="2">Thankyou<br /><br /><br /> Pete Newman<br /> Information Systems <br /> Institute of Physics<br /> Tel No 0117
9301249<br/> Fax No 0117 9301183<br /> Peter.Newman@iop.org<br /> http://www.iop.org</font><p>
************************************************************************<p>This email (and attachments) are
confidentialand intended for the addressee(s) only. If you are not the intended recipient please notify the sender,
deleteany copies and do not take action in reliance on it. Any views expressed are the author's and do not represent
thoseof IOP, except where specifically stated. IOP takes reasonable precautions to protect against viruses but accepts
noresponsibility for loss or damage arising from virus infection. For the protection of IOP's systems and staff emails
arescanned automatically.<p> IOP Publishing Limited Registered in England under Registration No 467514. Registered
Office:Dirac House, Temple Back, Bristol BS1 6BE England  

Re: 100% CPU

From
"Jim C. Nasby"
Date:
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