From: | "Jon Norman" <jnorman(at)alumni(dot)utexas(dot)net> |
---|---|
To: | "Rainer Bauer" <usenet(at)munnin(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: fsync and Windows XP |
Date: | 2009-07-07 21:03:23 |
Message-ID: | 71C5B18DD4D54BA1A5828B8CC90C3C7C@normanm90 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | jacob | 2009-07-07 22:33:55 | FW: Query length limitation in postgres server > 8.2.9 |
Previous Message | Greg Stark | 2009-07-07 09:26:30 | Re: Best way to simulate Booleans |