Re: win32 performance - fsync question - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: win32 performance - fsync question
Date
Msg-id 200502270054.j1R0s0822782@candle.pha.pa.us
Whole thread Raw
In response to Re: win32 performance - fsync question  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-hackers
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: idea for concurrent seqscans
Next
From: Neil Conway
Date:
Subject: Re: idea for concurrent seqscans