Re: Direct I/O issues

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Direct I/O issues
Date: 2006-11-24 04:06:05
Message-ID: 200611240406.kAO465O07686@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance

Greg Smith wrote:
> 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.

Please send an updated patch for test_fsync.c so we can get it working
for 8.2.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2006-11-24 04:09:25 Re: Avg performance for int8/numeric
Previous Message Andrew Dunstan 2006-11-24 02:45:05 Re: 8.2 open items list

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2006-11-24 04:09:25 Re: Avg performance for int8/numeric
Previous Message Mark Kirkwood 2006-11-23 22:08:39 Avg performance for int8/numeric

Browse pgsql-performance by date

  From Date Subject
Next Message Guido Neitzer 2006-11-24 08:22:45 Re: Postgres scalability and performance on windows
Previous Message Heikki Linnakangas 2006-11-23 22:50:45 Re: Postgres scalability and performance on windows