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 BDE479FA692 for ; Tue, 13 Jun 2006 19:05:17 -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 38283-01 for ; Tue, 13 Jun 2006 19:05:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 74C199FA68D for ; Tue, 13 Jun 2006 19:05:11 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 1324056427; Tue, 13 Jun 2006 17:05:10 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 13 Jun 2006 17:05:09 -0500 Date: Tue, 13 Jun 2006 17:05:09 -0500 From: "Jim C. Nasby" To: John Vincent Cc: pgsql-performance@postgresql.org Subject: Re: scaling up postgres Message-ID: <20060613220509.GJ34196@pervasive.com> 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> <20060613192609.GX34196@pervasive.com> <20060613212124.GD34196@pervasive.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060613:pgsql-performance@lusis.org::9LklVb9G61Szj1G/:0000000000 0000000000000000000000002OaG X-Hashcash: 1:20:060613:pgsql-performance@postgresql.org::wrDSEXf5I70Mh6Cc:00000 0000000000000000000000000mGz X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/215 X-Sequence-Number: 19572 On Tue, Jun 13, 2006 at 05:40:58PM -0400, John Vincent wrote: > Maybe from a postgresql perspective the cpus may be useless but the memory > on the pSeries can't be beat. We've been looking at running our warehouse > (PGSQL) in a LoP lpar but I wasn't able to find a LoP build of 8.1. Probably just because not many people have access to that kind of hardware. Have you tried building on Linux on Power? Also, I believe Opterons can do up to 4 DIMMs per memory controller, so with 2G sticks an 8 way Opteron could hit 64GB, which isn't exactly shabby, and I suspect it'd cost quite a bit less than a comperable p570... > We've been thrilled with the performance of our DB2 systems that run on > AIX/Power 5 but since the DB2 instance memory is limited to 18GB, we've got > two 86GB p570s sitting there being under utilized. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461