100% CPU

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.

Thank you

Pete Newman
Information Systems
Institute of Physics
Tel No 0117 9301249
Fax No 0117 9301183
Peter(dot)Newman(at)iop(dot)org
http://www.iop.org
<p>
************************************************************************<p>

This email (and attachments) are confidential and intended for the addressee(s) only. If you are not the intended recipient please notify the sender, delete any copies and do not take action in reliance on it. Any views expressed are the author's and do not represent those of IOP, except where specifically stated. IOP takes reasonable precautions to protect against viruses but accepts no responsibility for loss or damage arising from virus infection. For the protection of IOP's systems and staff emails are scanned automatically.<p>

IOP Publishing Limited Registered in England under Registration No 467514. Registered Office: Dirac House, Temple Back, Bristol BS1 6BE England