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 20CD19FA38F for ; Tue, 13 Jun 2006 19:21:30 -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 35179-08 for ; Tue, 13 Jun 2006 19:21:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 4908C9FA1A8 for ; Tue, 13 Jun 2006 19:21:22 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so16901ugf for ; Tue, 13 Jun 2006 15:21:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=SxNnxb6+1FahB0GK0Spltf3KqaPN/v+LJlK5yCJ/dFLeMst5lb16nVCMepDmAoC0WIT/UWYEcP++OHY2J7HRJ1/c8viOEs2Ycksd5qdcqIaLtkrbPo7zPtabYOcJi01cyuWFt+R7g7YabViBPgzi4SSz/qqQyd+CmAHVyFLYDq0= Received: by 10.66.250.17 with SMTP id x17mr28259ugh; Tue, 13 Jun 2006 15:21:21 -0700 (PDT) Received: by 10.66.216.11 with HTTP; Tue, 13 Jun 2006 15:21:21 -0700 (PDT) Message-ID: Date: Tue, 13 Jun 2006 18:21:21 -0400 From: "John Vincent" To: "Jim C. Nasby" Subject: Re: scaling up postgres Cc: pgsql-performance@postgresql.org In-Reply-To: <20060613220509.GJ34196@pervasive.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_11424_6759269.1150237281333" 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> <20060613220509.GJ34196@pervasive.com> X-Google-Sender-Auth: 6b7d6a3d2bbb8f65 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/217 X-Sequence-Number: 19574 ------=_Part_11424_6759269.1150237281333 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 6/13/06, Jim C. Nasby wrote: > > 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? Actually it's on my radar. I was looking for a precompiled build first (we actually checked the Pervasive and Bizgres sites first since we're considering a support contract) before going the self-compiled route. When I didn't see a pre-compiled build available, I started looking at the developer archives and got a little worried that I wouldn't want to base my job on a self-built Postgres on a fairly new (I'd consider Power 5 fairly new) platform. As it stands we're currently migrating to an IBM x445 (8 XPU Xeon, 16GB of memory) that was our old DB2 production server. 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... This is true. In our case I couldn't get the approval for the new hardware since we had two x445 boxes sitting there doing nothing (I wanted them for our VMware environment personally). Another sticking point is finding a vendor that will provide a hardware support contract similar to what we have with our existing IBM hardware (24x7x4). Since IBM has f-all for Opteron based systems and we've sworn off Dell, I was pretty limited. HP was able to get in on a pilot program and we're considering them now for future hardware purchases but beyond Dell/IBM/HP, there's not much else that can provide the kind of hardware support turn-around we need. > 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 > -- John E. Vincent ------=_Part_11424_6759269.1150237281333 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 6/13/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
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?

Actually it's on my radar. I was looking for a precompiled build first (we actually checked the Pervasive and Bizgres sites first since we're considering a support contract) before going the self-compiled route. When I didn't see a pre-compiled build available, I started looking at the developer archives and got a little worried that I wouldn't want to base my job on a self-built Postgres on a fairly new (I'd consider Power 5 fairly new) platform.

As it stands we're currently migrating to an IBM x445 (8 XPU Xeon, 16GB of memory) that was our old DB2 production server.

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...

This is true. In our case I couldn't get the approval for the new hardware since we had two x445 boxes sitting there doing nothing (I wanted them for our VMware environment personally). Another sticking point is finding a vendor that will provide a hardware support contract similar to what we have with our existing IBM hardware (24x7x4). Since IBM has f-all for Opteron based systems and we've sworn off Dell, I was pretty limited. HP was able to get in on a pilot program and we're considering them now for future hardware purchases but beyond Dell/IBM/HP, there's not much else that can provide the kind of hardware support turn-around we need.

> 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



--
John E. Vincent
------=_Part_11424_6759269.1150237281333--