> -----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])

Reply via email to