Re: Win32 Powerfail testing - results - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Win32 Powerfail testing - results
Date
Msg-id 8468.1044309134@sss.pgh.pa.us
Whole thread Raw
In response to Re: Win32 Powerfail testing - results  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
"Dave Page" <dpage@vale-housing.co.uk> 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


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: new procedural language - PL/R
Next
From: Jan Wieck
Date:
Subject: Re: Windows Build System - My final thoughts