Performance tuning for postgres - Mailing list pgsql-performance

From Yogesh Naik
Subject Performance tuning for postgres
Date
Msg-id 6B75622C2FF30547B96A565D6A6B0B70CCF591A7F3@EXCHANGE.persistent.co.in
Whole thread Raw
Responses Re: Performance tuning for postgres  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Performance tuning for postgres  (Robert Haas <robertmhaas@gmail.com>)
List 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.

pgsql-performance by date:

Previous
From: Anj Adu
Date:
Subject: slow query
Next
From: tv@fuzzy.cz
Date:
Subject: Re: slow query