From: Greg Smith <greg@2ndquadrant.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: SSD + RAID
Date: Sun, 28 Feb 2010 00:06:36 -0500
Message-ID: <4B89F9DC.6010304@2ndquadrant.com> (raw)
In-Reply-To: <4B89EB7C.8040606@cheapcomplexdevices.com>
References: <201002272016.o1RKGXp26284@momjian.us>
<4B89EB7C.8040606@cheapcomplexdevices.com>
Ron Mayer wrote:
> Linux apparently sends FLUSH_CACHE commands to IDE drives in the
> exact sample places it sends SYNCHRONIZE CACHE commands to SCSI
> drives[2].
> [2] http://hardware.slashdot.org/comments.pl?sid=149349&cid=12519114
>
Well, that's old enough to not even be completely right anymore about
SATA disks and kernels. It's FLUSH_CACHE_EXT that's been added to ATA-6
to do the right thing on modern drives and that gets used nowadays, and
that doesn't necessarily do so on most of the SSDs out there; all of
which Bruce's recent doc additions now talk about correctly.
There's this one specific area we know about that the most popular
systems tend to get really wrong all the time; that's got the
appropriate warning now with the right magic keywords that people can
look into it more if motivated. While it would be nice to get super
thorough and document everything, I think there's already more docs in
there than this project would prefer to have to maintain in this area.
Are we going to get into IDE, SATA, SCSI, SAS, FC, and iSCSI? If the
idea is to be complete that's where this would go. I don't know that
the documentation needs to address every possible way every possible
filesystem can be flushed.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, rm_pg@cheapcomplexdevices.com, bruce@momjian.us
Subject: Re: SSD + RAID
In-Reply-To: <4B89F9DC.6010304@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox