Re: Bug in VACUUM FULL ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in VACUUM FULL ?
Date
Msg-id 22509.1173884321@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in VACUUM FULL ?  ("Pavan Deolasee" <pavan.deolasee@enterprisedb.com>)
List pgsql-hackers
"Pavan Deolasee" <pavan.deolasee@enterprisedb.com> writes:
> If that assumption is true (and it must be true for us to move
> the chain in pieces), doesn't that mean we don't really need to
> move the RECENTLY_DEAD tuples preceding a DEAD tuple ?

As I've already said several times: they are dead, but at least for
VACUUM FULL's purposes it seems unreasonably difficult to determine that
and remove them.  The point at which we'd figure this out is after we've
already performed dead-tuple removal (at least for some of the pages
involved).  It would make for a significant increase in logical
complexity, and that code is too damn complicated already.  Since we
know this is a seldom-seen corner case, I'm not going to risk
introducing new bugs to recycle a few tuples a bit sooner.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Daylight Saving Time question PostgreSQL 8.1.4
Next
From: Hannu Krosing
Date:
Subject: Re: [PATCHES] Bitmapscan changes