Re: How to choose a disc array for Postgresql?

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/

In response to

Browse pgsql-performance by date

  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