Postgres Pro
Downloads
Home   >   mailing lists

Re: Does VACUUM reorder tables on clustered indices - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Does VACUUM reorder tables on clustered indices
Date
Msg-id 7723.1135912493@sss.pgh.pa.us
Whole thread Raw
In response to Re: Does VACUUM reorder tables on clustered indices  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Does VACUUM reorder tables on clustered indices  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom, has this bug been addressed or documented?

No.  Please add a TODO:

* Make CLUSTER preserve recently-dead tuples per MVCC requirements

I have not tested, but I suspect the table-rewriting variants of ALTER TABLE
have the same problem.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Does VACUUM reorder tables on clustered indices
Next
From: Bruce Momjian
Date:
Subject: Re: Does VACUUM reorder tables on clustered indices