X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4257F9FA13E for ; Tue, 13 Jun 2006 16:28:55 -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 14834-09 for ; Tue, 13 Jun 2006 16:28:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 322D09F9316 for ; Tue, 13 Jun 2006 16:28:51 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Tue, 13 Jun 2006 19:28:50 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 13 Jun 2006 14:28:49 -0500 Subject: Re: scaling up postgres From: Scott Marlowe To: Zydoon Cc: pgsql-performance@postgresql.org In-Reply-To: <448DE0DB.1020107@planet.tn> References: <200606030931.k539V38Y007877@smtp2.planet.net.tn> <20060603094355.GA23297@uio.no> <1150062140.23423.0.camel@localhost.localdomain> <448D3B65.7090709@aeccom.com> <448DE0DB.1020107@planet.tn> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1150226929.29299.54.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 13 Jun 2006 14:28:49 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/197 X-Sequence-Number: 19554 On Mon, 2006-06-12 at 16:47, Zydoon wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Thank you for sharing this. > Coming back to my problem :) A very faithful partner accepted to > gracefully borrow us 3 Pseries (bi-ppc + 2G RAM not more). with linux on > them. > Now I'm trying to make my tests, and I'm not that sure I will make the > switch to the PSeries, since my dual xeon with 4 G RAM can handle 3500 > concurrent postmasters consuming 3.7 G of the RAM. I cannot reach this > number on the PSeries with 2 G. > > can someone give me advice ? > BTW, I promise, at the end of my tests, I'll publish my report. Search the performance archives for the last 4 or 5 months for PPC / pseries machines. You'll find a very long thread about the disappointing performance the tester got with a rather expensive P Series machine. And his happy ending of testing on an Opteron machine.