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 88AA532A6B1 for ; Tue, 12 Oct 2004 01:28:28 +0100 (BST) 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 19369-10 for ; Tue, 12 Oct 2004 00:28:16 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7C2B932A623 for ; Tue, 12 Oct 2004 01:28:18 +0100 (BST) Received: from [134.22.69.18] (dyn-69-18.tor.dsl.tht.net [134.22.69.18]) by tht.net (Postfix) with ESMTP id 3098677887; Mon, 11 Oct 2004 14:21:11 -0400 (EDT) Subject: Re: IBM P-series machines (was: Excessive context From: Rod Taylor To: Andrew Sullivan Cc: Postgresql Performance In-Reply-To: <20041011173819.GB22076@phlogiston.dyndns.org> References: <4162CA14.6080206@lulu.com> <200410050947.36174.josh@agliodbs.com> <20041011173819.GB22076@phlogiston.dyndns.org> Content-Type: text/plain Message-Id: <1097518852.54644.20.camel@home> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Mon, 11 Oct 2004 14:20:52 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/148 X-Sequence-Number: 8624 On Mon, 2004-10-11 at 13:38, Andrew Sullivan wrote: > On Tue, Oct 05, 2004 at 09:47:36AM -0700, Josh Berkus wrote: > > As long as you're on x86, scaling outward is the way to go. If you want to > > continue to scale upwards, ask Andrew Sullivan about his experiences running > > PostgreSQL on big IBM boxes. But if you consider an quad-Opteron server > > expensive, I don't think that's an option for you. > The 650s are not cheap, but boy are they fast. I don't have any > numbers I can share, but I can tell you that we recently had a few > days in which our write load was as large as the entire write load > for last year, and you couldn't tell. It is too early for us to say > whether the P series lives up to its billing in terms of relibility: > the real reason we use these machines is reliability, so if > approaching 100% uptime isn't important to you, the speed may not be > worth it. Agreed completely, and the 570 knocks the 650 out of the water -- nearly double the performance for math heavy queries. Beware vendor support for Linux on these things though -- we ran into many of the same issues with vendor support on the IBM machines as we did with the Opterons.