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

From Tom Lane
Subject Re: Is VACUUM still crash-safe?
Date
Msg-id 7726.976556215@sss.pgh.pa.us
Whole thread Raw
In response to RE: Is VACUUM still crash-safe?  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> 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?

> I don't know how bad is it for TOAST tables though.

I still don't see anything here that affects the handling of TOAST
tables, which was Hiroshi's original complaint.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: suggest remove of elog in xlog.c
Next
From: Thomas Lockhart
Date:
Subject: Re: Unknown-type resolution rules, redux