<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