From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Magnus Hagander <mha(at)sollentuna(dot)net>, pgsql-hackers(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com> |
Subject: | Re: Changing the default wal_sync_method to open_sync for |
Date: | 2005-03-17 04:31:59 |
Message-ID: | 200503170431.j2H4VxZ22924@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-hackers-win32 |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Notice we never default to open_sync. However, on Win32, Magnus got a
> > 60% speedup by using open_sync, implemented using
> > FILE_FLAG_WRITE_THROUGH. Now, because this the fastest on Win32, I
> > think we should default to open_sync on Win32. The attached patch
> > implements this.
>
> ... and breaks open_datasync for all other platforms ...
Oh, fixed.
--
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
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 941 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2005-03-17 05:11:46 | Re: invalidating cached plans |
Previous Message | Bruce Momjian | 2005-03-17 04:29:09 | Re: [pgsql-hackers-win32] win32 performance - fsync question |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2005-03-17 05:32:20 | Re: Changing the default wal_sync_method to open_sync for |
Previous Message | Bruce Momjian | 2005-03-17 04:29:09 | Re: [pgsql-hackers-win32] win32 performance - fsync question |