Re: Direct I/O issues - Mailing list pgsql-performance

From Greg Smith
Subject Re: Direct I/O issues
Date
Msg-id Pine.GSO.4.64.0611231249410.29593@westnet.com
Whole thread Raw
In response to Re: Direct I/O issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Direct I/O issues  (Bruce Momjian <bruce@momjian.us>)
List pgsql-performance
On Thu, 23 Nov 2006, Tom Lane wrote:

> * It does not check for errors (if it had, you might have realized the
>  other problem).

All the test_fsync code needs to check for errors better; there have been
multiple occasions where I've run that with quesiontable input and it
didn't complain, it just happily ran and reported times that were almost
0.

Thanks for the note about alignment, I had seen something about that in
the xlog.c but wasn't sure if that was important in this case.

It's very important to the project I'm working on that I get this cleared
up, and I think I'm in a good position to fix it myself now.  I just
wanted to report the issue and get some initial feedback on what's wrong.
I'll try to rewrite that code with an eye toward the "Determine optimal
fdatasync/fsync, O_SYNC/O_DSYNC options" to-do item, which is what I'd
really like to have.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Direct I/O issues
Next
From: Brad Nicholson
Date:
Subject: Re: Priority to a mission critical transaction