From: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Steve Poe <steve.poe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to choose a disc array for Postgresql?
Date: Mon, 03 Mar 2008 11:38:21 -0800
Message-ID: <47CC53AD.6090602@cheapcomplexdevices.com> (raw)
In-Reply-To: <Pine.GSO.4.64.0803030011310.16718@westnet.com>
References: <721b21dc0803012337u55ddaa13l5517816659f8e100@mail.gmail.com>
<Pine.GSO.4.64.0803030011310.16718@westnet.com>
Greg Smith wrote:
> On Sat, 1 Mar 2008, Steve Poe wrote:
>> SATA over SCSI?
>
> I've collected up many of the past list comments on this subject and put
> a summary at
> http://www.postgresqldocs.org/index.php/SCSI_vs._IDE/SATA_Disks
Should this section:
ATA Disks... Always default to the write cache
enabled....turn it off....
be amended to say that if you have an OS that supports write
barriers (linuxes newer than early 2005) you shouldn't worry
about this?
And perhaps the SCSI section should also be amended to say that
that the same 2.6 kernels that fail to send the IDE FLUSH CACHE
command also fail to send the SCSI SYNCHRONIZE CACHE command,
so you should go through the same cache-disabling hoops there?
References from the Linux SATA driver guy and lwn here:
http://hardware.slashdot.org/comments.pl?sid=149349&cid=12519114http://lwn.net/Articles/77074/
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: rm_pg@cheapcomplexdevices.com, gsmith@gregsmith.com, steve.poe@gmail.com
Subject: Re: How to choose a disc array for Postgresql?
In-Reply-To: <47CC53AD.6090602@cheapcomplexdevices.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