Re: Performance tuning for postgres

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Yogesh Naik <Yogesh_Naik(at)persistent(dot)co(dot)in>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance tuning for postgres
Date: 2010-06-10 16:44:27
Message-ID: AANLkTimE7PvzHQnzm-j1I7LE4mad08c6cK6Y3C_TXg2V@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jun 4, 2010 at 12:40 AM, Yogesh Naik
<Yogesh_Naik(at)persistent(dot)co(dot)in> wrote:
> 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....

That sounds normal to me. What would you expect to happen?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Anj Adu 2010-06-10 16:58:59 Re: slow query performance
Previous Message Robert Haas 2010-06-10 16:42:02 Re: slow query performance