Re: win32 performance - fsync question

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: win32 performance - fsync question
Date: 2005-02-18 15:11:18
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A762D@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32 pgsql-performance

Magnus prepared a trivial patch which added the O_SYNC flag for windows
and mapped it to FILE_FLAG_WRITE_THROUGH in win32_open.c. We pg_benched
it and here are the results of our test on my WinXP workstation on a 10k
raptor:

Settings were pgbench -t 100 -c 10.

fsync = off:
~ 280 tps

fsync on, WAL=fsync:
~ 35 tps

fsync on, WAL=open_sync write cache policy on:
~ 240 tps

fsync on, WAL=open_sync write cache policy off:
~ 80 tps

80 tps, btw, is about the results I'd expect from linux on this
hardware. Also, the open_sync method plays much nicer with RAID
devices, but it would need some more rigorous testing before I'd
personally certify it as safe. As an aside, it doesn't look like the
open_sync can be trusted with write caching policy on the disk (the
default), and that's worth noting.

Merlin

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2005-02-18 15:14:19 Re: Help me recovering data
Previous Message Tom Lane 2005-02-18 14:37:10 Re: SPI_finish and RegisterExprContextCallback

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Magnus Hagander 2005-02-18 16:28:09 Re: win32 performance - fsync question
Previous Message Andreas Pflug 2005-02-18 11:17:15 Re: replication for win32

Browse pgsql-performance by date

  From Date Subject
Next Message Rodrigo Moreno 2005-02-18 15:43:58 RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin
Previous Message Tom Lane 2005-02-18 14:59:52 Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin