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: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>,<pgsql-hackers-win32(at)postgresql(dot)org>,"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question
Date: 2005-02-27 11:15:13
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE4769D0@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
I'd like to see this one also considered for 8.0.x, though I'd certainly
like to see some more testing as well. Perhaps it's suitable for the
"8.0.x with extended testing" that is planned for the ARC replacement
code?

It does make a huge difference on win32. While we definitly don't want
to risk data, a 60% speedup in write intensive apps is a *lot*.

//Magnus


>-----Original Message-----
>From: pgsql-hackers-win32-owner(at)postgresql(dot)org 
>[mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf Of 
>Bruce Momjian
>Sent: den 27 februari 2005 01:54
>To: Magnus Hagander
>Cc: Tom Lane; pgsql-hackers(at)postgresql(dot)org; 
>pgsql-hackers-win32(at)postgresql(dot)org; Merlin Moncure
>Subject: Re: [pgsql-hackers-win32] [HACKERS] win32 performance 
>- fsync question
>
>
>
>Patch applied.  Thanks.
>
>I assume this is not approprate for 8.0.X.
>
>---------------------------------------------------------------
>------------
>
>
>Magnus Hagander wrote:
>> > 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.
>> 
>> 
>> //Magnus
>
>Content-Description: o_sync.patch
>
>[ Attachment, skipping... ]
>
>> 
>> ---------------------------(end of 
>broadcast)---------------------------
>> TIP 8: explain analyze is your friend
>
>-- 
>  Bruce Momjian                        |  http://candle.pha.pa.us
>  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
>  +  If your life is a hard drive,     |  13 Roberts Road
>  +  Christ can be your backup.        |  Newtown Square, 
>Pennsylvania 19073
>
>---------------------------(end of 
>broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
>

Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2005-02-27 11:26:22
Subject: Re: win32 performance - fsync question
Previous:From: Michael PaesoldDate: 2005-02-27 10:47:15
Subject: Re: win32 performance - fsync question

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2005-02-27 11:26:22
Subject: Re: win32 performance - fsync question
Previous:From: Michael PaesoldDate: 2005-02-27 10:47:15
Subject: Re: win32 performance - fsync question

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