Guillaume Lelarge <guillaume(at)lelarge(dot)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
In response to
pgsql-performance by date
|Next:||From: bricklen||Date: 2008-12-30 18:59:23|
|Subject: Poor plan choice in prepared statement|
|Previous:||From: Robert Haas||Date: 2008-12-30 14:50:55|
|Subject: Re: perform 1 check vs exception when unique_violation|