> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: 03 February 2003 21:52 > To: Dave Page > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [HACKERS] Win32 Powerfail testing - results > > > "Dave Page" <[EMAIL PROTECTED]> writes: > > Rod Taylor allegedly said: > >> Any change of tossing in a periodic VACUUM or would that throw off > >> the results? > > > Dunno, Tom could best answer that, but a *complete guess* based on > > piecing together tidbits of how it all works from various threads > > here, would be that it would merely increase the time period during > > which a powerfail would be unlikely to cause duplicate > rows. Reasoning > > for this is that vacuum would be messing with tuples that > are already > > dead. > > I think it'd be interesting to try it both ways. VACUUM > might throw in new failure modes. I'm not sure if it could > mask the failure mode you already found.
OK, I'll bung Win2K back on the test box tomorrow. Any preference as to the type of vacuum? I assume full would be most likely to cause problems. I'll add the vacuum after the commit... Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])