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 7969B3A60EB for ; Tue, 7 Dec 2004 02:51:37 +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 78199-08 for ; Tue, 7 Dec 2004 02:51:30 +0000 (GMT) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD9D3A60E3 for ; Tue, 7 Dec 2004 02:51:32 +0000 (GMT) Received: from jefftrout.com ([24.128.241.68]) by comcast.net (rwcrmhc13) with SMTP id <2004120702512901500nh6m7e>; Tue, 7 Dec 2004 02:51:30 +0000 Received: (qmail 70744 invoked from network); 7 Dec 2004 02:51:29 -0000 Received: from unknown (HELO ?192.168.0.100?) (10.10.10.20) by 10.10.10.10 with SMTP; 7 Dec 2004 02:51:29 -0000 In-Reply-To: <41B4E8B6.6059.1FBEABB@localhost> References: <41B4E8B6.6059.1FBEABB@localhost> Mime-Version: 1.0 (Apple Message framework v619) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <0736B0F0-47FB-11D9-A0F2-000393D1F76E@torgo.978.org> Content-Transfer-Encoding: 7bit Cc: pgsql-performance@postgresql.org From: Jeff Subject: Re: scaling beyond 4 processors Date: Mon, 6 Dec 2004 21:52:26 -0500 To: vogler@cipsoft.com X-Mailer: Apple Mail (2.619) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.653 tagged_above=0 required=5 tests=RCVD_BY_IP, URIBL_SBL X-Spam-Level: X-Archive-Number: 200412/127 X-Sequence-Number: 9502 On Dec 6, 2004, at 5:18 PM, vogler@cipsoft.com wrote: > 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. > I'm assuming you've already done as much query tweaking as possible. and are you sure you are CPU bound and not IO bound? (Symptoms of IO bound are low cpu usage, high load average, poor performance. Many processes in "D" state) > So the question is: Has anyone experiences with running Postgres on > systems with > more than 4 processors in a production environment? Which systems and Have you also considered a replicated approach? -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/