X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 14806DB892 for ; Wed, 16 Nov 2005 10:35:22 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17051-05 for ; Wed, 16 Nov 2005 14:35:24 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 166CFD6D16 for ; Wed, 16 Nov 2005 10:35:18 -0400 (AST) Received: from toad.mtbrook.bozemanpass.com (toad.mtbrook.bozemanpass.com [69.145.82.195]) by svr2.postgresql.org (Postfix) with ESMTP id 534BCF0C44 for ; Wed, 16 Nov 2005 14:35:22 +0000 (GMT) Received: from [69.145.82.253] (unknown [69.145.82.253]) by toad.mtbrook.bozemanpass.com (Postfix) with ESMTP id 263A11102E6; Wed, 16 Nov 2005 06:35:20 -0800 (PST) Message-ID: <437B43AB.7050104@boreham.org> Date: Wed, 16 Nov 2005 07:35:23 -0700 From: David Boreham User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Steve Wampler Cc: "Joshua D. Drake" , Alex Turner , Luke Lonergan , Adam Weisberg , pgsql-performance@postgresql.org Subject: Re: Hardware/OS recommendations for large databases ( References: <3E37B936B592014B978C4415F90D662D01995F7B@MI8NYCMAIL06.Mi8.com> <33c6269f0511152115v1a34ab81j30f1f5df5a6c6956@mail.gmail.com> <437B3B18.1040509@commandprompt.com> <437B4258.8050507@noao.edu> In-Reply-To: <437B4258.8050507@noao.edu> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/275 X-Sequence-Number: 15532 Steve Wampler wrote: >Joshua D. Drake wrote: > > >>The reason you want the dual core cpus is that PostgreSQL can only >>execute 1 query per cpu at a time,... >> >> > >Is that true? I knew that PG only used one cpu per query, but how >does PG know how many CPUs there are to limit the number of queries? > > > He means only one query can be executing on each cpu at any particular instant.