Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-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

pgsql-performance by date

Next:From: Guido NeitzerDate: 2006-11-24 08:22:45
Subject: Re: Postgres scalability and performance on windows
Previous:From: Heikki LinnakangasDate: 2006-11-23 22:50:45
Subject: Re: Postgres scalability and performance on windows

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group