From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Fwd: Multiple disks: RAID 5 or PG Cluster
Date: Sat, 18 Jun 2005 18:57:49 -0400
Message-ID: <20050618225748.GI25854@mathom.us> (raw)
In-Reply-To: <b47a630c09af1837a54c23c8b1c3c01f@implements.be>
References: <b47a630c09af1837a54c23c8b1c3c01f@implements.be>
On Sat, Jun 18, 2005 at 06:42:27PM +0200, Yves Vindevogel wrote:
>>With striping, each file is distributed over several disks, making
>>the physical write faster because several disks can do the work.
>>Same for reading, multiple disks return a part of the file.
A mirror behaves almost exactly the same for reads, with a caveat: for a
large enough file, multiple disks *must* be accessed in a striped
configuration, while in a mirrored configuration the controller may
access either one or more disks to read any file.
>>BTW: mirroring is always slower than striping.
That's simply not true. Striping speeds up writes but has no advantage
over a simlarly sized mirror for reading. In fact, the mirror will be
faster for pathological cases in which the reads are aligned in such a
way that they would all be have to be read from the same stripe of a
striped array. The striped configuration has an advantage when more than
two disks are used, but that derives from the number of spindles, not
from the striping; it is possible to have a mirror of more than two
disks (which would have the same read advantage as the striped
configuration with the same number of disks) but this is rarely seen
because it is expensive.
Mike Stone
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: mstone+postgres@mathom.us
Subject: Re: Fwd: Multiple disks: RAID 5 or PG Cluster
In-Reply-To: <20050618225748.GI25854@mathom.us>
* 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