Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Maybe VACUUM FULL could reorder index pages and truncate to recover disk
> space. But this is very costly, so there could be a "VACUUM REALLY
> FULL" or something :-)
At that point I would think REINDEX would be a better answer.
regards, tom lane