From: William Yu <wyu@talisys.com>
To: pgsql-performance@postgresql.org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: Sat, 24 Dec 2005 19:43:52 -0800
Message-ID: <dol4hh$o0l$1@news.hub.org> (raw)
In-Reply-To: <3E37B936B592014B978C4415F90D662D01F1B59F@MI8NYCMAIL06.Mi8.com>
References: <3E37B936B592014B978C4415F90D662D01F1B59F@MI8NYCMAIL06.Mi8.com>
Luke Lonergan wrote:
> Note that host-based SCSI raid cards from LSI, Adaptec, Intel, Dell, HP
> and others have proven to have worse performance than a single disk
> drive in many cases, whether for RAID0 or RAID5. In most circumstances
This is my own experience. Running a LSI MegaRAID in pure passthrough
mode + Linux software RAID10 is a ton faster than configuring the RAID
via the LSI card. One of the things I've noticed is that the card does
not seem to be able to parallel read on mirrors. While looking at iostat
under Linux, I can see software RAID1 reading all drives and the MD
number adding up to the sum of all drives.
The ARECA SATA controller I just got though doesn't seem to exhibit
these problems. Performance is a few % points above Linux software RAID
at lower CPU usage. In fact, I'm getting better single-threaded
bandwidth on a 4x7200RPM SATA config versus a 6x15K SCSI config on the
LSI. The drives are bigger for the SATA drive (300GB) versus 36GB for
the SCSI so that means the heads don't have to move any where as much
and can stay on the fast portion of the disk. Haven't had a chance to
test multi-user DB between the two setup though.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wyu@talisys.com
Subject: Re: What's the best hardver for PostgreSQL 8.1?
In-Reply-To: <dol4hh$o0l$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox