On Fri, Jun 4, 2010 at 12:40 AM, Yogesh Naik
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: htt
Is this a bulk insert? Are you wrapping your statements within a
transaction(s)?
How many columns in the table? What do the table statistics look like?
On Fri, Jun 4, 2010 at 9:21 AM, Michael Gould <
mgo...@intermodalsoftwaresolutions.net> wrote:
> In my opinion it depends on the application,
In my opinion it depends on the application, the priority of the application
and whether or not it is a commercially sold product, but depending on your
needs you might want to consider having a 3rd party vendor who has expertise
in this process review and help tune the application. One vendor tha
Yogesh Naik 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
>
> I have also done optimization on queries too...
>
> Is there any way to optimized the CPU utilization for postgres
