Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 73BE8633C9E for ; Thu, 8 Apr 2010 03:08:19 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28861-07 for ; Thu, 8 Apr 2010 06:08:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by mail.postgresql.org (Postfix) with ESMTP id D0FC26327E6 for ; Thu, 8 Apr 2010 03:08:08 -0300 (ADT) Received: from [192.168.0.105] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0LwG3q-1NSEdU2oLm-017XUg; Thu, 08 Apr 2010 08:08:07 +0200 Message-ID: <4BBD72C5.8060204@2ndquadrant.com> Date: Thu, 08 Apr 2010 02:08:05 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: David Rees CC: pgsql-performance@postgresql.org Subject: Re: Occasional giant spikes in CPU load References: <4BBCFB12.1010306@emolecules.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1/w7Obk2blUMwFTE9Z71wKKFpuKGWRuh+vlGYx 22ONlEGhoGohw6B7xkJPvi4bR2UFHhEn9bfmw3Pl1jdFcG6yph UOhXc2DTgfMnkboAh+7J5mTc4jdvQMh X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201004/90 X-Sequence-Number: 38340 David Rees wrote: > You need to find out what all those Postgres processes are doing. You > might try enabling update_process_title and then using ps to figure > out what each instance is using. That's what the addition of "-c" to top I suggested does on Linux; it shows the updated process titles where the command line is in the default config. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us