From: Alan Stange <stange@rentec.com>
To: Joseph Shraibman <jks@selectacast.net>
Cc: J. Andrew Rogers <jrogers@neopolitan.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: linux distro for better pg performance
Date: Mon, 03 May 2004 23:03:55 -0400
Message-ID: <4097081B.7020006@rentec.com> (raw)
In-Reply-To: <40970058.3040608@selectacast.net>
References: <407E25A6.ADFE4815@t1.unisoftbg.com>
<407E909F.9000101@ehpg.net>
<1082053706.10823.38.camel@localhost.localdomain>
<40970058.3040608@selectacast.net>
Joseph Shraibman wrote:
> J. Andrew Rogers wrote:
>
>> Do these features make a difference? Far more than you would
>> imagine. On one postgres server I just upgraded, we went from a 3Ware
>> 8x7200-RPM
>> RAID-10 configuration to an LSI 320-2 SCSI 3x10k RAID-5, with 256M
>
> Is raid 5 much faster than raid 10? On a 4 disk array with 3 data
> disks and 1 parity disk, you have to write 4/3rds the original data,
> while on raid 10 you have to write 2 times the original data, so
> logically raid 5 should be faster.
I think this comparison is a bit simplistic. For example, most raid5
setups have full stripes that are more than 8K (the typical IO size in
postgresql), so one might have to read in portions of the stripe in
order to compute the parity. The needed bits might be in some disk or
controller cache; if it's not then you lose. If one is able to
perform full stripe writes then the raid5 config should be faster for
writes.
Note also that the mirror has 2 copies of the data, so that the read IOs
would be divided across 2 (or more) spindles using round robin or a more
advanced algorithm to reduce seek times.
Of course, I might be completely wrong...
-- Alan
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: stange@rentec.com, jks@selectacast.net, jrogers@neopolitan.com
Subject: Re: linux distro for better pg performance
In-Reply-To: <4097081B.7020006@rentec.com>
* 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