Re: Simplifying wal_sync_method

On Wed, Aug 10, 2005 at 02:11:48AM -0500, Thomas F. O'Connell wrote:
> I was recently witness to a benchmark of 7.4.5 on Solaris 9 wherein  
> it was apparently demonstrated that fsync was the fastest option  
> among the 7.4.x wal_sync_method options.
> 
> If there's a way to make this information more useful by providing  
> more data, please let me know, and I'll see what I can do.

What would be really interesting to me to know is what Sun did
between 8 and 9 to make that so.  We don't use Solaris for databases
any more, but fsync was a lot slower than whatever we ended up using
on 8.  I wouldn't be surprised if they'd wired fsync directly to
something else; but I can hardly believe it'd be faster than any
other option.  (Mind, we were using Veritas filesyste with this, as
well, which was at least half the headache.)

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun