Re: [HACKERS] Concurrent VACUUM: first results

Vadim Mikheev <vadim@krs.ru>

From: Vadim Mikheev <vadim@krs.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Hiroshi Inoue <Inoue@tpf.co.jp>, Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-hackers@postgreSQL.org
Date: 1999-11-26T06:42:07Z
Lists: pgsql-hackers
Tom Lane wrote:
> 
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> >> I wonder whether there isn't a cleaner way to do this.
> 
> > I think there exists another reason.
> > We couldn't delete index tuples for deleted but not yet committed
> > heap tuples.
> 
> My first thought was "Good point".  But my second was "why should
> vacuum need to deal with that case?".  If vacuum grabs an exclusive
> lock on a relation, it should *not* ever see tuples with uncertain
> commit status, no?

What if vacuum will crash after deleting index tuples pointing
to heap tuples in old places but before commit? Index will
be broken.

Vadim