Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Which reminds me that you wanted to make VACUUM FULL do the equivalent
> of a REINDEX instead of retail deletion of index entries ... is that
> still the idea? Would it do that always, or only under certain
> conditions?
It's still on the to-do list. I ws envisioning that it would switch
strategies based on how many tuples it needed to move --- the REINDEX
is only a win if you're moving a large fraction of the table. But the
details are all still TBD.
regards, tom lane