Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 48B7A632F8A for ; Wed, 2 Jun 2010 09:56:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 64797-01 for ; Wed, 2 Jun 2010 12:56:43 +0000 (UTC) X-Greylist: delayed 01:08:13.640326 by SQLgrey-1.7.6 Received: from smtpq2.tb.mail.iss.as9143.net (smtpq2.tb.mail.iss.as9143.net [212.54.42.165]) by mail.postgresql.org (Postfix) with ESMTP id DD2DD632BCA for ; Wed, 2 Jun 2010 09:56:44 -0300 (ADT) Received: from [212.54.42.136] (helo=smtp5.tb.mail.iss.as9143.net) by smtpq2.tb.mail.iss.as9143.net with esmtp (Exim 4.69) (envelope-from ) id 1OJmQu-0008R7-V1 for pgsql-performance@postgresql.org; Wed, 02 Jun 2010 13:48:28 +0200 Received: from 5353294f.cable.casema.nl ([83.83.41.79] helo=data.antarean.org) by smtp5.tb.mail.iss.as9143.net with esmtp (Exim 4.69) (envelope-from ) id 1OJmQo-0000e2-SC for pgsql-performance@postgresql.org; Wed, 02 Jun 2010 13:48:22 +0200 Received: from localhost (localhost [127.0.0.1]) by data.antarean.org (Postfix) with ESMTP id 748EB713 for ; Wed, 2 Jun 2010 13:48:22 +0200 (CEST) X-Virus-Scanned: amavisd-new at antarean.org Received: from data.antarean.org ([127.0.0.1]) by localhost (data.antarean.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kJfJ4ka-p9YW for ; Wed, 2 Jun 2010 13:48:22 +0200 (CEST) Received: from eve.localnet (eve.lan.antarean.org [10.20.13.50]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by data.antarean.org (Postfix) with ESMTPS id 2424E62C for ; Wed, 2 Jun 2010 13:48:22 +0200 (CEST) From: "J. Roeleveld" To: pgsql-performance@postgresql.org Subject: Re: Overusing 1 CPU Date: Wed, 2 Jun 2010 13:48:21 +0200 User-Agent: KMail/1.12.4 (Linux/2.6.30-gentoo-r5; KDE/4.3.5; x86_64; ; ) References: <1275477160.1818.48.camel@stefaans-laptop> <1275478657.1818.53.camel@stefaans-laptop> In-Reply-To: <1275478657.1818.53.camel@stefaans-laptop> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201006021348.21572.joost@antarean.org> X-ZiggoSMTP-MailScanner-Information: Please contact the ISP for more information X-ZiggoSMTP-MailScanner-ID: 1OJmQo-0000e2-SC X-ZiggoSMTP-MailScanner: Found to be clean X-ZiggoSMTP-MailScanner-SpamCheck: geen spam, SpamAssassin (niet cached, score=0.001, vereist 5, autolearn=not spam, BAYES_50 0.00) X-ZiggoSMTP-MailScanner-From: joost@antarean.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/25 X-Sequence-Number: 38881 On Wednesday 02 June 2010 13:37:37 Mozzi wrote: > Hi > > Thanx mate Create Index seems to be the culprit. > Is it normal to just use 1 cpu tho? If it is a single-threaded process, then yes. And a "Create index" on a single table will probably be single-threaded. If you now start a "create index" on a different table, a different CPU should be used for that. > > Mozzi > > On Wed, 2010-06-02 at 12:24 +0100, Matthew Wakeling wrote: > > On Wed, 2 Jun 2010, Mozzi wrote: > > > This box is basically adle @ the moment as it is still in testing yet > > > top shows high usage on just 1 of the cores. > > > > First port of call: What process is using the CPU? Run top on a fairly > > wide terminal and use the "c" button to show the full command line. > > > > Matthew >