From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
Cc: | Steve Poe <steve(dot)poe(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: How to choose a disc array for Postgresql? |
Date: | 2008-03-03 19:38:21 |
Message-ID: | 47CC53AD.6090602@cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | alan bryan | 2008-03-03 23:39:35 | Performance tuning on FreeBSD |
Previous Message | Tom Lane | 2008-03-03 17:25:13 | Re: Performance problems deleting data |