Re: [HACKERS] Re: WAL and commit_delay

2001-02-19 Thread Jan Wieck
Tom Lane wrote: > Adriaan Joubert <[EMAIL PROTECTED]> writes: > > fdatasync() is available on Tru64 and according to the man-page behaves > > as Tom expects. So it should be a win for us. > > Careful ... HPUX's man page also claims that fdatasync does something > useful, but it doesn't. I'd recom

Re: [HACKERS] Re: WAL and commit_delay

2001-02-18 Thread Nathan Myers
On Sun, Feb 18, 2001 at 11:51:50AM -0500, Tom Lane wrote: > Adriaan Joubert <[EMAIL PROTECTED]> writes: > > fdatasync() is available on Tru64 and according to the man-page behaves > > as Tom expects. So it should be a win for us. > > Careful ... HPUX's man page also claims that fdatasync does som

Re: [HACKERS] Re: WAL and commit_delay

2001-02-18 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > BTW, UnixWare 7.1.1 does *NOT* have fdatasync. What standard created > this one? HP's manpage quoth: STANDARDS CONFORMANCE fsync(): AES, SVID3, XPG3, XPG4, POSIX.4 fdatasync(): POSIX.4 regards, tom lane

Re: [HACKERS] Re: WAL and commit_delay

2001-02-18 Thread Tom Lane
Adriaan Joubert <[EMAIL PROTECTED]> writes: > fdatasync() is available on Tru64 and according to the man-page behaves > as Tom expects. So it should be a win for us. Careful ... HPUX's man page also claims that fdatasync does something useful, but it doesn't. I'd recommend an experiment. Does t

Re: [HACKERS] Re: WAL and commit_delay

2001-02-18 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [010218 10:53]: > Adriaan Joubert <[EMAIL PROTECTED]> writes: > > fdatasync() is available on Tru64 and according to the man-page behaves > > as Tom expects. So it should be a win for us. > > Careful ... HPUX's man page also claims that fdatasync does something > us

[HACKERS] Re: WAL and commit_delay

2001-02-18 Thread Adriaan Joubert
fdatasync() is available on Tru64 and according to the man-page behaves as Tom expects. So it should be a win for us. What do other commercial unixes say? Adriaan

Re: [HACKERS] Re: WAL and commit_delay

2001-02-17 Thread Tom Lane
[EMAIL PROTECTED] (Nathan Myers) writes: > I.e. yes, Linux 2.4.0 and ext2 do implement the distinction. > Sorry for the misinformation. Okay ... meanwhile I've got to report the reverse: I've just confirmed that on HPUX 10.20, there is *not* a distinction between fsync and fdatasync. I was misle

Re: [HACKERS] Re: WAL and commit_delay

2001-02-17 Thread Nathan Myers
On Sat, Feb 17, 2001 at 07:34:22PM -0500, Tom Lane wrote: > [EMAIL PROTECTED] (Nathan Myers) writes: > > In the 2.4 kernel it says (fs/buffer.c) > > >/* this needs further work, at the moment it is identical to fsync() */ > >down(&inode->i_sem); > >err = file->f_op->fsync(file, dentry

Re: [HACKERS] Re: WAL and commit_delay

2001-02-17 Thread Tom Lane
[EMAIL PROTECTED] (Nathan Myers) writes: > In the 2.4 kernel it says (fs/buffer.c) >/* this needs further work, at the moment it is identical to fsync() */ >down(&inode->i_sem); >err = file->f_op->fsync(file, dentry); >up(&inode->i_sem); Hmm, that's the same code that's been ther

Re: [HACKERS] Re: WAL and commit_delay

2001-02-17 Thread Nathan Myers
On Sat, Feb 17, 2001 at 06:30:12PM -0500, Brent Verner wrote: > On 17 Feb 2001 at 17:56 (-0500), Tom Lane wrote: > > [snipped] > > | Is anyone out there running a 2.4 Linux kernel? Would you try pgbench > | with current sources, commit_delay=0, -B at least 1024, no -F, and see > | how the resul

[HACKERS] Re: WAL and commit_delay

2001-02-17 Thread Brent Verner
On 17 Feb 2001 at 17:56 (-0500), Tom Lane wrote: [snipped] | Is anyone out there running a 2.4 Linux kernel? Would you try pgbench | with current sources, commit_delay=0, -B at least 1024, no -F, and see | how the results change when pg_fsync is made to call fdatasync instead | of fsync? (It's