"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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])