From: Michael Gould <mgould@intermodalsoftwaresolutions.net>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Performance tuning for postgres
Date: Fri, 4 Jun 2010 09:21:53 -0500
Message-ID: <09a0f171aace2115f4e73089dac0e1da@intermodalsoftwaresolutions.net> (raw)
In-Reply-To: <4C08C0970200002500031F33@gw.wicourts.gov>
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 that I
know does this is EnterpriseDB. I've worked with other SQL engines and have
a lot of experience tuning queries in a couple of the environments but
PostGresql isn't one of them. Having an experienced DBA review your system
can make the difference between night and day.
Best Regards
Michael Gould
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> wrote:
> Yogesh Naik <Yogesh_Naik@persistent.co.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....
>>
>> I have also done optimization on queries too...
>>
>> Is there any way to optimized the CPU utilization for postgres....
>
> We'd need a lot more information before we could make useful
> suggestions. Knowing something about your hardware, OS, exact
> PostgreSQL version, postgresql.conf contents, the table definition,
> any foreign keys or other constraints, and exactly how you're doing
> the inserts would all be useful. Please read this and repost:
>
> http://wiki.postgresql.org/wiki/SlowQueryQuestions
>
> -Kevin
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mgould@intermodalsoftwaresolutions.net
Subject: Re: Performance tuning for postgres
In-Reply-To: <09a0f171aace2115f4e73089dac0e1da@intermodalsoftwaresolutions.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox