Re: win32 performance - fsync question - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: win32 performance - fsync question
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A7625@Herge.rcsinc.local
Whole thread Raw
In response to win32 performance - fsync question  ("E.Rodichev" <er@sai.msu.su>)
List pgsql-hackers
> looking for the way how to increase performance at Windows XP box, I
found
> the parameters
>
> #fsync = true                   # turns forced synchronization on or
off
> #wal_sync_method = fsync        # the default varies across platforms:
>                                  # fsync, fdatasync, open_sync, or
> open_datasync
>
> I have no idea how it works with win32. May I try fsync = false, or it
is
> dangerous? Which of wal_sync_method may I try at WinXP?

wal_sync_method does nothing on XP.  The fsync option will tremendously
increase performance on writes at the cost of possible data corruption
in the event of a expected server power down.

The main performance difference between win32 and various unix systems
is that fsync() takes much longer on win32 than linux.

Merlin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange RETURN NEXT behaviour in Postgres 8.0
Next
From: Greg Stark
Date:
Subject: Re: Help me recovering data