Re: [SQL] fsync and Windows XP

2009-07-07 Thread Jon Norman
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

Re: [SQL] fsync and Windows XP

2009-07-06 Thread Rainer Bauer
"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:

[SQL] fsync and Windows XP

2009-06-30 Thread Jon Norman
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.