| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: win32 performance - fsync question |
| Date: | 2005-02-17 19:14:00 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A7629@Herge.rcsinc.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-17 19:20:50 | Re: win32 performance - fsync question |
| Previous Message | Evgeny Rodichev | 2005-02-17 18:56:59 | Re: win32 performance - fsync question |