Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-hackers-win32] win32 performance - fsync question

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>,"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>,"Evgeny Rodichev" <er(at)sai(dot)msu(dot)su>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question
Date: 2005-02-20 16:54:02
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE47690A@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
>> 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. 
>
>Attached is this trivial patch. As Merlin says, it needs some more
>reliability testing. But the numbers are at least reasonable - it
>*seems* like it's doing the right thing (as long as you turn off write
>cache). And it's certainly a significant performance increase - it
>brings the speed almost up to the same as linux.

For testing, I have built and uploaded binaries from the 8.0 stable
branch with this patch applied. They are available from
http://www.hagander.net/pgsql/. Install the 8.0.1 version first (from
MSI or manually, your choice), then replace postmaster.exe and
postgres.exe with the ones in the ZIP file. If you're running as a
service, make sure to stop the service first.

To make sure it uses the new code, change wal_sync_method to open_sync
in postgresql.conf and restart the service.

The kind of testing we need help is "pulling the plug reliability
testing". For this, make sure you have write caching turned off (it's no
the disks properties page in the Device Manager), run a bunch of
transactions on the db and then pull the plug of the machine in the
middle. It should come up with all acknowledged transactions still
applied, and all others not.


//Magnus

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-02-20 17:30:51
Subject: Re: Get rid of system attributes in pg_attribute?
Previous:From: lsunleyDate: 2005-02-20 16:52:47
Subject: SMP buffer management test question

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2005-02-22 03:43:02
Subject: Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Previous:From: Magnus HaganderDate: 2005-02-18 16:28:09
Subject: Re: win32 performance - fsync question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group