Re: SSD + RAID - Mailing list pgsql-performance

From Ron Mayer
Subject Re: SSD + RAID
Date
Msg-id 4B89EB7C.8040606@cheapcomplexdevices.com
Whole thread Raw
In response to Re: SSD + RAID  (Bruce Momjian <bruce@momjian.us>)
Responses Re: SSD + RAID
Re: SSD + RAID
List pgsql-performance
Bruce Momjian wrote:
> Greg Smith wrote:
>> Bruce Momjian wrote:
>>> I have added documentation about the ATAPI drive flush command, and the
>>
>> If one of us goes back into that section one day to edit again it might
>> be worth mentioning that FLUSH CACHE EXT is the actual ATAPI-6 command
>> that a drive needs to support properly.  I wouldn't bother with another
>> doc edit commit just for that specific part though, pretty obscure.
>
> That setting name was not easy to find so I added it to the
> documentation.

If we're spelling out specific IDE commands, it might be worth
noting that the corresponding SCSI command is "SYNCHRONIZE CACHE"[1].


Linux apparently sends FLUSH_CACHE commands to IDE drives in the
exact sample places it sends SYNCHRONIZE CACHE commands to SCSI
drives[2].

It seems that the same file systems, SW raid layers,
virtualization platforms, and kernels that have a problem
sending FLUSH CACHE commands to SATA drives have he same exact
same problems sending SYNCHRONIZE CACHE commands to SCSI drives.
With the exact same effect of not getting writes all the way
through disk caches.

No?


[1] http://linux.die.net/man/8/sg_sync
[2] http://hardware.slashdot.org/comments.pl?sid=149349&cid=12519114

pgsql-performance by date:

Previous
From: Chris
Date:
Subject: Re: How to troubleshoot high mem usage by postgres?
Next
From: Greg Smith
Date:
Subject: Re: SSD + RAID