Re: How to choose a disc array for Postgresql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux