Re: win32 performance - fsync question

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: win32 performance - fsync question
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A7629@Herge.rcsinc.local
обсуждение исходный текст
Ответ на win32 performance - fsync question  ("E.Rodichev" <er@sai.msu.su>)
Список pgsql-hackers
> > WinXP  fsync = true     20-28 tps
> > WinXP  fsync = false      600 tps
> > Linux  fsync = true       800 tps
> > Linux  fsync = false      980 tps
>
> Wow, that's terrible on Windows.  If there's a solution, it'd be nice
to
> backport it...
>

there is.  I just rigged up a test benchmark comparing sync methods.  I
ran on 2 boxes, my xp workstation on 10k raptor and a win2k server on
3ware raid 5 (also on 10k raptors).

Workstation:
did 1000 FILE_FLAG_WRITE_THROUGH | FILE_FLAG_NO_BUFFERING writes in
5.729633 seconds
did 1000 FILE_FLAG_WRITE_THROUGH writes in 0.593322 seconds
did 1000 flushfilebuffers writes in 15.898989 seconds

server:
did 1000 FILE_FLAG_WRITE_THROUGH | FILE_FLAG_NO_BUFFERING writes in
16.501076 seconds
did 1000 FILE_FLAG_WRITE_THROUGH writes in 16.104133 seconds
did 1000 flushfilebuffers writes in 18.962439 seconds

server after running super altra secret dskcache '+p' mode:
did 1000 FILE_FLAG_WRITE_THROUGH | FILE_FLAG_NO_BUFFERING writes in
0.256574 seconds
did 1000 FILE_FLAG_WRITE_THROUGH writes in 2.627602 seconds
did 1000 flushfilebuffers writes in 15.290967 seconds

dskcache.exe is required to enable power protect mode (unbypassing raid
conttoller write cache settings) on win2k.

enjoy.
Merlin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Evgeny Rodichev
Дата:
Сообщение: Re: win32 performance - fsync question
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: win32 performance - fsync question