Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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