From: | "Michael Paesold" <mpaesold(at)gmx(dot)at> |
---|---|
To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net> |
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: win32 performance - fsync question |
Date: | 2005-02-27 10:47:15 |
Message-ID: | 054801c51cb9$b53e1780$0a01a8c0@zaphod |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-hackers-win32 |
Bruce Momjian wrote:
> 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.
The original patch did not have any documentation. Have you added some?
Since this has to be configured in GUC (wal_sync_method), the implications
should be documented somewhere, no?
Best Regards,
Michael Paesold
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-02-27 11:15:13 | Re: [pgsql-hackers-win32] win32 performance - fsync question |
Previous Message | Neil Conway | 2005-02-27 05:53:42 | Re: idea for concurrent seqscans |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2005-02-27 11:15:13 | Re: [pgsql-hackers-win32] win32 performance - fsync question |
Previous Message | Bruce Momjian | 2005-02-27 00:54:00 | Re: win32 performance - fsync question |