From: Ron <rjpeace@earthlink.net>
To: David Lang <dlang@invendra.net>
To: pgsql-performance@postgresql.org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: Sat, 24 Dec 2005 17:45:20 -0500
Message-ID: <6.2.5.6.0.20051224172653.01dd4c08@earthlink.net> (raw)
In-Reply-To: <Pine.LNX.4.62.0512241350010.2807@qnivq.ynat.uz>
References: <43A84D03.7090002@ritek.hu>
<docq5v$24ea$1@news.hub.org>
<200512212209.50234.caseroj@comcast.net>
<200512212231.55100.caseroj@comcast.net>
<20051224135042.484c6e32.frank@wiles.org>
<6.2.5.6.0.20051224161551.01dc5d98@earthlink.net>
<Pine.LNX.4.62.0512241350010.2807@qnivq.ynat.uz>
At 04:54 PM 12/24/2005, David Lang wrote:
>raid 5 is bad for random writes as you state, but how does it do for
>sequential writes (for example data mining where you do a large
>import at one time, but seldom do other updates). I'm assuming a
>controller with a reasonable amount of battery-backed cache.
The issue with RAID 5 writes centers on the need to recalculate
checksums for the ECC blocks distributed across the array and then
write the new ones to physical media.
Caches help, and the bigger the cache the better, but once you are
doing enough writes fast enough (and that doesn't take much even with
a few GBs of cache) the recalculate-checksums-and-write-new-ones
overhead will decrease the write speed of real data. Bear in mind
that the HD's _raw_ write speed hasn't been decreased. Those HD's
are pounding away as fast as they can for you. Your _effective_ or
_data level_ write speed is what decreases due to overhead.
Side Note: people often forget the other big reason to use RAID 10
over RAID 5. RAID 5 is always only 2 HD failures from data
loss. RAID 10 can lose up to 1/2 the HD's in the array w/o data loss
unless you get unlucky and lose both members of a RAID 1 set.
This can be seen as an example of the classic space vs. time trade
off in performance tuning. You can use 2x the HDs you need and
implement RAID 10 for best performance and reliability or you can
dedicate less HD's to RAID and implement RAID 5 for less (write)
performance and lower reliability.
TANSTAAFL.
Ron Peacetree
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: rjpeace@earthlink.net, dlang@invendra.net
Subject: Re: What's the best hardver for PostgreSQL 8.1?
In-Reply-To: <6.2.5.6.0.20051224172653.01dd4c08@earthlink.net>
* 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