Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 76D0D6338B7 for ; Fri, 4 Jun 2010 11:45:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 60062-10 for ; Fri, 4 Jun 2010 14:45:07 +0000 (UTC) X-Greylist: delayed 00:23:09.398222 by SQLgrey-1.7.6 Received: from serv01.siteground178.com (ns1.siteground178.com [67.15.255.19]) by mail.postgresql.org (Postfix) with ESMTP id 22AE16335BB for ; Fri, 4 Jun 2010 11:45:06 -0300 (ADT) Received: from [67.15.255.19] (port=55165 helo=intermodalsoftwaresolutions.net) by serv01.siteground178.com with esmtpa (Exim 4.69) (envelope-from ) id 1OKXmT-00074r-Ew for pgsql-performance@postgresql.org; Fri, 04 Jun 2010 09:21:53 -0500 Received: from phpmailer ([76.106.235.204]) by intermodalsoftwaresolutions.net with HTTP (PHPMailer); Fri, 4 Jun 2010 09:21:53 -0500 Date: Fri, 4 Jun 2010 09:21:53 -0500 To: "pgsql-performance@postgresql.org" From: Michael Gould Subject: Re: Performance tuning for postgres Message-ID: <09a0f171aace2115f4e73089dac0e1da@intermodalsoftwaresolutions.net> X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: <4C08C0970200002500031F33@gw.wicourts.gov> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - serv01.siteground178.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - intermodalsoftwaresolutions.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/85 X-Sequence-Number: 38941 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" wrote: > Yogesh Naik wrote: > =20 >> 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.... >>=20 >> I have also done optimization on queries too... >>=20 >> Is there any way to optimized the CPU utilization for postgres.... > =20 > 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: > =20 > http://wiki.postgresql.org/wiki/SlowQueryQuestions > =20 > -Kevin >=20 > --=20 > Sent via pgsql-performance mailing list = (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >=20 -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax