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 3380F52849 for ; Thu, 2 Jun 2005 01:34:07 -0300 (ADT) 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 53139-03 for ; Thu, 2 Jun 2005 04:34:01 +0000 (GMT) Received: from smtp-gw-cl-d.dmv.com (smtp-gw-cl-d.dmv.com [216.240.97.42]) by svr1.postgresql.org (Postfix) with ESMTP id 0756A52875 for ; Thu, 2 Jun 2005 01:33:59 -0300 (ADT) Received: from mail-gw-cl-b.dmv.com (mail-gw-cl-b.dmv.com [216.240.97.39]) by smtp-gw-cl-d.dmv.com (8.12.10/8.12.10) with ESMTP id j524Xvm4060284; Thu, 2 Jun 2005 00:33:57 -0400 (EDT) (envelope-from sven@dmv.com) Received: from [64.45.134.154] (dogpound.dyndns.org [64.45.134.154]) by mail-gw-cl-b.dmv.com (8.12.9/8.12.9) with ESMTP id j524Xu2Q060798; Thu, 2 Jun 2005 00:33:57 -0400 (EDT) (envelope-from sven@dmv.com) Message-ID: <429E8CA7.7080805@dmv.com> Date: Thu, 02 Jun 2005 00:35:51 -0400 From: Sven Willenberger User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Stacy White Cc: pgsql-performance@postgresql.org Subject: Re: Adaptec/LSI/?? RAID References: <002601c56725$2bdd2010$0200a8c0@grownups> In-Reply-To: <002601c56725$2bdd2010$0200a8c0@grownups> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.48 on 216.240.97.42 X-Scanned-By: MIMEDefang 2.48 on 216.240.97.39 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.331 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200506/24 X-Sequence-Number: 12662 Stacy White presumably uttered the following on 06/01/05 23:42: > We're in the process of buying another Opteron server to run Postgres, and > based on the suggestions in this list I've asked our IT director to get an > LSI MegaRaid controller rather than one of the Adaptecs. > > But when we tried to place our order, our vendor (Penguin Computing) advised > us: > > "we find LSI does not work well with 4GB of RAM. Our engineering find that > LSI card could cause system crashes. One of our customer ... has found that > Adaptec cards works well on PostGres SQL -- they're using it as a preforce > server with xfs and post-gress." > > Any comments? Suggestions for other RAID controllers? > > > ---------------------------(end of broadcast)--------------------------- We use the LSI MegaRaid 320-2x with the battery-backed cache on a dual opteron system that uses 8G of RAM. OS is FreeBSD amd64 (5.4) and runs without hesitation. Database currently over 100GB and it performs admirably. So chalk one anecdotal item towards the LSI column. To be fair I have not tried an Adaptec card with this setup so I cannot comment positively or negatively on that card. As a side note, we did have issues with this setup with Linux (2.6 kernel - 64bit) and XFS file system (we generally use FreeBSD but I wanted to try other 64bit OSes before committing). Whether the linux issues were due to the LSI, memory, Tyan mobo, or something else was never determined -- FreeBSD ran it and did so without flinching so our choice was easy. HTH Sven