Re: [HACKERS] TODO: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options

2006-06-08 Thread Tom Lane
Josh Berkus writes: > "Performs best" is pretty elusive. On Solaris 10, for example, fdatasync > does best on pgbench on x86, but opendatasync does best on DBT2 on Sparc. > I'm not certain we can really determine this with any accuracy. Yeah, if it were easy we've have done it already :-(.

Re: [HACKERS] TODO: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options

2006-06-08 Thread Josh Berkus
Tom, JD, > No, that only tells you if the various alternatives *work*. Not which > one performs best. "Performs best" is pretty elusive. On Solaris 10, for example, fdatasync does best on pgbench on x86, but opendatasync does best on DBT2 on Sparc. I'm not certain we can really determine th

Re: [HACKERS] TODO: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options

2006-06-08 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Doesn't this exist in: > src/tools/fsync? No, that only tells you if the various alternatives *work*. Not which one performs best. regards, tom lane ---(end of broadcast)--- T

[HACKERS] TODO: Determine optimal fdatasync/fsync, O_SYNC/O_DSYNC options

2006-06-08 Thread Joshua D. Drake
Doesn't this exist in: src/tools/fsync? Do we just need to make it more user friendly? Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 19