Re: O_DIRECT support for Windows - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: O_DIRECT support for Windows
Date
Msg-id 20070328083654.GD11810@svr2.hagander.net
Whole thread Raw
In response to Re: O_DIRECT support for Windows  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
On Wed, Mar 28, 2007 at 02:47:12PM +0900, ITAGAKI Takahiro wrote:
> Magnus Hagander <magnus@hagander.net> wrote:
> 
> > IIRC, we're still waiting for performance numbers showing there exists a
> > win from this patch.
> 
> Here is a performance number of Direct I/O support on Windows.
> There was 10%+ of performance win on pgbench (263.33 vs. 290.79) in O_DIRECT.

That sounds good enough to go for it.


> However, I only have a desktop-class machine for Windows.
> (Pendium 4 3.6GHz with HT, 3GB of RAM, 2 ATA-drives)
> Test on production-class machines might show different results.

Yes, that would be very good. I don't have any "server-grade" machines I
can run it on ATM. But perhaps someone else does. Stefan, you mentioned you
might have one to run other tests for me - can you run this one? Do you
have a build system on it?

> In addition, I'm slightly worried about aligment issues reported by Magnus.
> We might need fail-back-to-non-direct feature on error for safety.

A question is - is there risk that this works for weeks, and then suddenly
stops working, or will we detect it on the first attempt to write. If we
detect it on the first attempt, that's enough I think - the user can
configure it to use the old behaviour in that case. But if  there is a risk
that we hit it later on, we need to automatically fallback at the time of
the write.

//Magnus



pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Reduction in WAL for UPDATEs
Next
From: "Simon Riggs"
Date:
Subject: Re: [PATCHES] Full page writes improvement, code update