RE: Is VACUUM still crash-safe? - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Is VACUUM still crash-safe?
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D31EF@sectorbase1.sectorbase.com
Whole thread Raw
In response to Is VACUUM still crash-safe?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > If we move tuples in already committed state, a page with new
> > tuple position goes to disk and backend crashes before page with
> > old tuple position updated then we'll have two version of tuple
> > after restart (new tuple with HEAP_MOVED_IN is valid and there is
> > no HEAP_MOVED_OFF in old tuple version).
> 
> That's not good.  Perhaps VACUUM still needs to fsync the file before
> its internal commit?

Ops, sorry - this case is not relevant to 7.1: WAL guarantees that
both pages will be updated on restart. Seems we are safe now.

Vadim


pgsql-hackers by date:

Previous
From: Bruce Guenter
Date:
Subject: Re: Re: CRC
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Is VACUUM still crash-safe?