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: Mon, 22 Feb 2010 20:14:47 -0500
Message-ID: <4B832C07.60301@2ndquadrant.com> (raw)
In-Reply-To: <4B82C642.8020409@cheapcomplexdevices.com>
References: <201002221437.o1MEbDJ13005@momjian.us>
<4B82C642.8020409@cheapcomplexdevices.com>
Ron Mayer wrote:
> I know less about other file systems. Apparently the NTFS guys
> are aware of such stuff - but don't know what kinds of fsync equivalent
> you'd need to make it happen.
>
It's actually pretty straightforward--better than ext3. Windows with
NTFS has been perfectly aware how to do write-through on drives that
support it when you execute _commit for some time:
http://msdn.microsoft.com/en-us/library/17618685(VS.80).aspx
If you switch the postgresql.conf setting to fsync_writethrough on
Windows, it will execute _commit where it would execute fsync on other
platforms, and that pushes through the drive's caches as it should
(unlike fsync in many cases). More about this at
http://archives.postgresql.org/pgsql-hackers/2005-08/msg00227.php and
http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm (which
also covers OS X).
--
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: <4B832C07.60301@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