From: Jon Norman <jnorman@alumni.utexas.net>
To: Rainer Bauer <usenet@munnin.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: fsync and Windows XP
Date: Tue, 7 Jul 2009 16:03:23 -0500
Message-ID: <71C5B18DD4D54BA1A5828B8CC90C3C7C@normanm90> (raw)
References: <8709734C5D12419584134E5559985E63@normanm90>
<8g7m45tjp8c3q1qon9rkjfand1qiq4r0mu@4ax.com>
I've tried the different wal_sync_method settings and nothing seems to work.
I don't know if it matters, but I'm running PostgreSQL on an XP Embedded
system. Initially, I had most of my tables installed in the default
location, c:\program files\postgresql\8.3\data, on compact flash -- which is
protected with Enhanced Write Filter (EWF) and uses Hibernate Once Resume
Many (HORM). My log tables were mapped to a solid state drive using
tablespace definitions. This configuration didn't seem to work very well so
I ended up installing everything to the solid state drive that isn't being
protected with EWF and is not part of the hibernated image. When I
disconnect power from the system I'd like to see recently added records show
up on the next boot. If I perform a clean shutdown of the system the records
written to disk.
>
>>What is the trick for getting the fsync feature to work with Windows XP.
>> I've turned off disk caching and set fsync = on in my postgresql.conf,
>> but records are still not immediately written to disk.
>
> Check out the wal_sync_method parameter:
> <http://www.postgresql.org/docs/8.3/static/runtime-config-wal.html;
>
> Rainer
>
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-sql@postgresql.org
Cc: jnorman@alumni.utexas.net, usenet@munnin.com
Subject: Re: fsync and Windows XP
In-Reply-To: <71C5B18DD4D54BA1A5828B8CC90C3C7C@normanm90>
* 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