From: Luke Lonergan <llonergan@greenplum.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Mike Biamonte <mike@dbeat.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Huge Data sets, simple queries
Date: Tue, 31 Jan 2006 15:19:38 -0800
Message-ID: <C005308A.1B642%llonergan@greenplum.com> (raw)
In-Reply-To: <20060131231227.GP95850@pervasive.com>
Jim,
On 1/31/06 3:12 PM, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
>> The alternating technique in mirroring might improve rotational latency for
>> random seeking - a trick that Tandem exploited, but it won't improve
>> bandwidth.
>
> Or just work in multiples of tracks, which would greatly reduce the
> impact of delays from seeking.
So, having rediscovered the facts underlying the age-old RAID10 versus RAID5
debate we're back to the earlier points.
RAID10 is/was the best option when latency / random seek was the predominant
problem to be solved, RAID5/50 is best where read bandwidth is needed.
Modern developments in fast CPUs for write checksumming have made RAID5/50 a
viable alternative to RAID10 even when there is moderate write / random seek
workloads and fast read is needed.
>>
>> Works great with standard OS write caching.
>
> Well, the only problem with that is if the machine crashes for any
> reason you risk having the database corrupted (or at best losing some
> committed transactions).
So, do you routinely turn off Linux write caching? If not, then there's no
difference.
- Luke
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: llonergan@greenplum.com, jnasby@pervasive.com, mike@dbeat.com
Subject: Re: Huge Data sets, simple queries
In-Reply-To: <C005308A.1B642%llonergan@greenplum.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