pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (8+ messages)  latest in thread

Message-ID: <4097081B.7020006@rentec.com>
Permalink:  ../4097081B.7020006@rentec.com/
Also on:    postgresql.org/message-id/4097081B.7020006@rentec.com

 · 

reply

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