Re: WAL write of full pages - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: WAL write of full pages
Date
Msg-id 1079385516.33643.7.camel@jester
Whole thread Raw
In response to Re: WAL write of full pages  (Marty Scholes <marty@outputservices.com>)
List pgsql-hackers
> I suspect (but cannot prove) that performance would jump for systems 
> like ours if WAL was done away with entirely and the individual data 
> files were synchronized on commit.

You know.. thats exactly what WAL is designed to prevent? Grab a copy of
7.0 and 7.1. Do a benchmark between the 2 with fsync on in both cases.

I think you'll find one is about 50% faster than the other on a single
disk system, and about the same if you have gobs of battery backed write
cache.




pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: WAL write of full pages
Next
From: Andrew Sullivan
Date:
Subject: Re: The Name Game: postgresql.net vs. pgfoundry.org