X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2EFC83A5FC2 for ; Mon, 6 Dec 2004 22:21:38 +0000 (GMT) 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 07073-03 for ; Mon, 6 Dec 2004 22:21:30 +0000 (GMT) Received: from mail.cipsoft.com (mail.cipsoft.com [62.146.47.42]) by svr1.postgresql.org (Postfix) with ESMTP id EF99E3A601E for ; Mon, 6 Dec 2004 22:21:29 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by mail.cipsoft.com (Postfix) with ESMTP id 93E031B8454 for ; Mon, 6 Dec 2004 23:21:27 +0100 (CET) Received: from mail.cipsoft.com ([127.0.0.1]) by localhost (regina.cipsoft.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23620-10 for ; Mon, 6 Dec 2004 23:21:27 +0100 (CET) Received: from sam.cipsoft.de (p5091D441.dip0.t-ipconnect.de [80.145.212.65]) by mail.cipsoft.com (Postfix) with ESMTP id 155F21B8160 for ; Mon, 6 Dec 2004 23:21:27 +0100 (CET) Received: from bilbo (bilbo.cipsoft.de [192.168.0.103]) by sam.cipsoft.de (Postfix) with ESMTP id 8054DC92DC for ; Mon, 6 Dec 2004 23:21:26 +0100 (CET) From: vogler@cipsoft.com To: pgsql-performance@postgresql.org Date: Mon, 06 Dec 2004 23:18:14 +0100 MIME-Version: 1.0 Subject: scaling beyond 4 processors Message-ID: <41B4E8B6.6059.1FBEABB@localhost> X-mailer: Pegasus Mail for Windows (4.21a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at mail.cipsoft.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.228 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200412/124 X-Sequence-Number: 9499 Hello everyone! Since our current Postgres server, a quad Xeon system, finally can't keep up with our load anymore we're ready to take the next step. So the question is: Has anyone experiences with running Postgres on systems with more than 4 processors in a production environment? Which systems and architectures are you using (e.g. IBM xseries, IBM pseries, HP Proliant, Sun Fire, 8- way Opteron)? How about conflicts between Postgres' shared memory approach and the NUMA architecture of most multi-processor machines? Maybe it's time to switch to Oracle or DB2, but before I give up on Postgres, I wanted to hear some other opinions. Thanks for any hints and suggestions. Best regards, Stephan Vogler CipSoft GmbH