Performance tuning for postgres

Поиск
Список
Период
Сортировка
От Yogesh Naik
Тема Performance tuning for postgres
Дата
Msg-id 6B75622C2FF30547B96A565D6A6B0B70CCF591A7F3@EXCHANGE.persistent.co.in
обсуждение исходный текст
Ответы Re: Performance tuning for postgres
Re: Performance tuning for postgres
Список 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 по дате отправления:

Предыдущее
От: Anj Adu
Дата:
Сообщение: slow query
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: slow query