RE: Is VACUUM still crash-safe?

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Is VACUUM still crash-safe?
Date: 2000-12-11 18:00:54
Message-ID: 8F4C99C66D04D4118F580090272A7A234D31EF@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Adriaan Joubert 2000-12-11 18:01:31 Re: RFC C++ Interface
Previous Message Bruce Guenter 2000-12-11 17:54:18 Re: Re: CRC