Re: How to choose a disc array for Postgresql? - Mailing list pgsql-performance

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=12519114
http://lwn.net/Articles/77074/