Guillaume Lelarge <guillaume@lelarge.info> writes:
> Laszlo Nagy a �crit :
>> We have serveral table where the index size is much bigger than the
>> table size.
>> ...
>> Vacuuming a table does not rebuild the indexes, am I right?
> Neither VACUUM nor VACUUM FULL rebuild the indexes. CLUSTER and REINDEX do.
In fact, VACUUM FULL tends to make indexes *more* bloated not less so.
One fairly likely explanation for how you got into this situation is
overeager use of VACUUM FULL.
regards, tom lane
