On Fri, 15 Aug 2008, Bruce Momjian wrote:
'data=writeback' is the recommended mount method for that file system, though I see that is not mentioned in our official documentation.
While writeback has good performance characteristics, I don't know that I'd go so far as to support making that an official recommendation. The integrity guarantees of that journaling mode are pretty weak. Sure the database itself should be fine; it's got the WAL as a backup if the filesytem loses some recently written bits. But I'd hate to see somebody switch to that mount option on this project's recommendation only to find some other files got corrupted on a power loss because of writeback's limited journalling. ext3 has plenty of problem already without picking its least safe mode, and recommending writeback would need a carefully written warning to that effect.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
