X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 565B6D1D56B for ; Sun, 11 Jan 2004 15:54:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62380-07 for ; Sun, 11 Jan 2004 11:53:48 -0400 (AST) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id 66C05D1D561 for ; Sun, 11 Jan 2004 11:53:39 -0400 (AST) Received: from lorenso.com (c-24-1-26-144.client.comcast.net[24.1.26.144]) by comcast.net (sccrmhc13) with ESMTP id <2004011115533801600nikgte>; Sun, 11 Jan 2004 15:53:38 +0000 Message-ID: <40017182.1090801@lorenso.com> Date: Sun, 11 Jan 2004 09:53:38 -0600 From: "D. Dante Lorenso" User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Postgresql on Quad CPU machine Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/104 X-Sequence-Number: 5279 I'm running PostgreSQL 7.4 on a quad Xeon attached to a beefy disk array. However, I am begining to wonder if this is a waste of CPU power. I think I read somewhere that PostgreSQL is NOT multi-threaded. But, will it be able to take advantage of multiple CPUs? Will I have to run separate postmaster instances to get the advantage? I'm not running a high load on that machine yet, So I can't tell if the load is being balanced across the CPUs. I expect that as some of the newly launched sites grow it will require more resources but maybe some of you could share your results of this type of deployment setup. Dante