Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 54BF39FA5DD
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  7 Feb 2007 23:57:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 97922-07 for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed,  7 Feb 2007 23:57:15 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from momjian.us (momjian.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id 425419FA4F0
	for <pgsql-docs@postgresql.org>; Wed,  7 Feb 2007 23:57:22 -0400 (AST)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id
 l183vMA29029;
	Wed, 7 Feb 2007 22:57:22 -0500 (EST)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200702080357.l183vMA29029@momjian.us>
Subject: Re: [HACKERS] [PATCHES] [PERFORM] Direct I/O issues
In-Reply-To: <Pine.GSO.4.64.0611250357070.29486@westnet.com>
To: Greg Smith <gsmith@gregsmith.com>
Date: Wed, 7 Feb 2007 22:57:22 -0500 (EST)
CC: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL123]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="ELM1170907042-26671-1_"
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/8
X-Sequence-Number: 4139


--ELM1170907042-26671-1_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

Greg Smith wrote:
> On Fri, 24 Nov 2006, Bruce Momjian wrote:
> 
> > OK, I modified test_fsync.c by copying the defines from xlog.c, and
> > fixed the O_DIRECT alignment and check write()/fsync().
> 
> I just tested your new test_fsync as included in the 8.2rc1, and it's 
> working perfectly for me now on Linux.  All the O_SYNC writes using 
> O_DIRECT are reporting realistic timings.  I'm happy that this code is 
> working as it should and appreciate the quick response.  I still think the 
> wal_sync_method documentation deserves an update noting that O_DIRECT is 
> used when available with the sync write methods.

O_DIRECT mention added, and backpatched to 8.2.X.

-- 
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

--ELM1170907042-26671-1_
Content-Transfer-Encoding: 7bit
Content-Type: text/x-diff
Content-Disposition: inline; filename="/rtmp/diff"

Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.108
diff -c -c -r1.108 config.sgml
*** doc/src/sgml/config.sgml	1 Feb 2007 00:28:16 -0000	1.108
--- doc/src/sgml/config.sgml	8 Feb 2007 03:52:01 -0000
***************
*** 1385,1390 ****
--- 1385,1391 ----
          Not all of these choices are available on all platforms.
          The default is the first method in the above list that is supported
          by the platform.
+         The <literal>open_</>* options also use <literal>O_DIRECT</> if available.
          This parameter can only be set in the <filename>postgresql.conf</>
          file or on the server command line.
         </para>

--ELM1170907042-26671-1_--