X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 03FB1D1B8AC for ; Fri, 29 Aug 2003 14:05:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 24437-08 for ; Fri, 29 Aug 2003 11:05:09 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 7A642D1B8E0 for ; Fri, 29 Aug 2003 11:05:04 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19sjsD-00035N-00 for ; Fri, 29 Aug 2003 10:05:09 -0400 Received: by dba2 (Postfix, from userid 1019) id C4002CF47; Fri, 29 Aug 2003 10:05:08 -0400 (EDT) Date: Fri, 29 Aug 2003 10:05:08 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Hardware recommendations to scale to silly load Message-ID: <20030829140503.GA19388@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <1061953146.18108.291.camel@haggis> <3F4E5DA9.6396.5C8916@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/492 X-Sequence-Number: 3308 On Fri, Aug 29, 2003 at 12:05:03AM -0700, William Yu wrote: > We should see a boost when we move to 64-bit Linux and hopefully another > one when NUMA for Linux is production-stable. According to the people who've worked with SGIs, NUMA actually seems to make things worse. It has something to do with how the shared memory is handled. You'll want to dig through the -general or -hackers archives from somewhere between 9 and 14 months ago, IIRC. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110