pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

fsync and Windows XP
3+ messages / 2 participants
[nested] [flat]

* fsync and Windows XP
@ 2009-06-30 16:43  Jon Norman <jnorman@alumni.utexas.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Jon Norman @ 2009-06-30 16:43 UTC (permalink / raw)
  To: pgsql-sql

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.

Any help would be appreciated.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: fsync and Windows XP
@ 2009-07-01 08:30  Rainer Bauer <usenet@munnin.com>
  parent: Jon Norman <jnorman@alumni.utexas.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Rainer Bauer @ 2009-07-01 08:30 UTC (permalink / raw)
  To: pgsql-sql

"Jon Norman" schrieb:

>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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: fsync and Windows XP
@ 2009-07-07 21:03  Jon Norman <jnorman@alumni.utexas.net>
  parent: Rainer Bauer <usenet@munnin.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jon Norman @ 2009-07-07 21:03 UTC (permalink / raw)
  To: Rainer Bauer <usenet@munnin.com>; +Cc: 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
>




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2009-07-07 21:03 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-06-30 16:43 fsync and Windows XP Jon Norman <jnorman@alumni.utexas.net>
2009-07-01 08:30 ` Rainer Bauer <usenet@munnin.com>
2009-07-07 21:03   ` Jon Norman <jnorman@alumni.utexas.net>

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