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