Re: Performance tuning for postgres

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 <
mgould(at)intermodalsoftwaresolutions(dot)net> wrote:

> 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(dot)Grittner(at)wicourts(dot)gov> wrote:
> > 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....
> >>
> >> 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(at)postgresql(dot)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
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>