pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPerformance tuning for postgres
5+ messages / 5 participants
[nested] [flat]
* Performance tuning for postgres
@ 2010-06-04 04:40 Yogesh Naik <Yogesh_Naik@persistent.co.in>
0 siblings, 2 replies; 5+ messages in thread
From: Yogesh Naik @ 2010-06-04 04:40 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Performance tuning for postgres
@ 2010-06-04 14:00 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Yogesh Naik <Yogesh_Naik@persistent.co.in>
1 sibling, 1 reply; 5+ messages in thread
From: Kevin Grittner @ 2010-06-04 14:00 UTC (permalink / raw)
To: Yogesh Naik <Yogesh_Naik@persistent.co.in>; pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Performance tuning for postgres
@ 2010-06-04 14:21 Michael Gould <mgould@intermodalsoftwaresolutions.net>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 5+ messages in thread
From: Michael Gould @ 2010-06-04 14:21 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Performance tuning for postgres
@ 2010-06-04 18:12 Bryan Hinton <bryan@bryanhinton.com>
parent: Michael Gould <mgould@intermodalsoftwaresolutions.net>
0 siblings, 0 replies; 5+ messages in thread
From: Bryan Hinton @ 2010-06-04 18:12 UTC (permalink / raw)
To: Michael Gould <mgould@intermodalsoftwaresolutions.net>; +Cc: pgsql-performance
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@intermodalsoftwaresolutions.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.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
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Performance tuning for postgres
@ 2010-06-10 16:44 Robert Haas <robertmhaas@gmail.com>
parent: Yogesh Naik <Yogesh_Naik@persistent.co.in>
1 sibling, 0 replies; 5+ messages in thread
From: Robert Haas @ 2010-06-10 16:44 UTC (permalink / raw)
To: Yogesh Naik <Yogesh_Naik@persistent.co.in>; +Cc: pgsql-performance
On Fri, Jun 4, 2010 at 12:40 AM, 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....
That sounds normal to me. What would you expect to happen?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-06-10 16:44 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-04 04:40 Performance tuning for postgres Yogesh Naik <Yogesh_Naik@persistent.co.in>
2010-06-04 14:00 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-06-04 14:21 ` Michael Gould <mgould@intermodalsoftwaresolutions.net>
2010-06-04 18:12 ` Bryan Hinton <bryan@bryanhinton.com>
2010-06-10 16:44 ` Robert Haas <robertmhaas@gmail.com>
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