Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C69399FB2E8 for ; Mon, 25 Sep 2006 05:47:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62964-10 for ; Mon, 25 Sep 2006 05:47:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id EF5159FB2B9 for ; Mon, 25 Sep 2006 05:47:40 -0300 (ADT) Received: from kingfisher.intern.logix-tt.com (p549D2185.dip0.t-ipconnect.de [84.157.33.133]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 7384D65977 for ; Mon, 25 Sep 2006 10:50:01 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 1C229181AC32F for ; Mon, 25 Sep 2006 10:47:41 +0200 (CEST) Message-ID: <451797AC.9010907@logix-tt.com> Date: Mon, 25 Sep 2006 10:47:40 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Thunderbird 1.5.0.5 (X11/20060812) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Multi-processor question References: In-Reply-To: X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.203 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/327 X-Sequence-Number: 21013 Hi, Kjell Tore, Kjell Tore Fossbakk wrote: > I got two AMD Opteron 885 processors (2.6ghz) and 8 gig of memory. > Harddrives are 4 scsi disks in 10 raid. > > I'm running gentoo, and the kernel finds and uses all of my 2 (4) cpu's. > > How can i actually verify that my PostgreSQL (or that my OS) actually > gives each new query a fresh idle CPU) all of my CPU's? On unixoid systems, use top to display individual CPU loads, they should be balanced, if you issue the same type of queries in parallel.[1] On Windows, the Task Manager should be able to display individual CPU load graphs. Note, however, that if you issue different kinds of queries in parallel, it is well possible that some CPUs have 100% load (on CPU-intensive queries), and the other CPUs have low load (processing the other, I/O intensive queries. Btw, if your queries need a long time, but CPU load is low, than it is very likely that you're I/O bound, either at the disks in the Server, or at the network connections to the clients. HTH, Markus [1] You might need some command line options or keys, e. G. on some debian boxes over here, one has to press "1" to switch a running top to multi-cpu mode, pressing "1" again switches back to accumulation. -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org