Performance tuning for postgres

From: Yogesh Naik <Yogesh_Naik(at)persistent(dot)co(dot)in>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Performance tuning for postgres
Date: 2010-06-04 04:40:58
Message-ID: 6B75622C2FF30547B96A565D6A6B0B70CCF591A7F3@EXCHANGE.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message tv 2010-06-04 08:13:23 Re: slow query
Previous Message Anj Adu 2010-06-04 01:45:30 slow query