Performance tuning for postgres

[Yogesh Naik <Yogesh_Naik@xxxxxxxxxxxxxxxx>]

Hi

I am performing a DB insertion and update for 3000+ records and while doing so i get CPU utilization
to 100% with 67% of CPU used by postgres....

I have also done optimization on queries too...

Is there any way to optimized the CPU utilization for postgres....

 

I am currently using postgres 8.3 version…

Help will be appreciated....

 

Regards

 

Yogesh Naik

DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.