On Fri, May 04, 2007 at 08:54:10AM -0600, Joel Dice wrote: > > My next question is this: what are the dangers of turning fsync off in the > context of a high-availablilty cluster using asynchronous replication?
My real question is why you want to turn it off. If you're using a battery-backed cache on your disk controller, then fsync ought to be pretty close to free. Are you sure that turning it off will deliver the benefit you think it will? > on Y. Thus, database corruption on X is irrelevant since our first step > is to drop them. Not if the corruption introduces problems for replication, which is indeed possible. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match