Re: win32 performance - fsync question

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: win32 performance - fsync question
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A7625@Herge.rcsinc.local
обсуждение исходный текст
Ответ на win32 performance - fsync question  ("E.Rodichev" <er@sai.msu.su>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange RETURN NEXT behaviour in Postgres 8.0
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Help me recovering data