Guillaume Lelarge <guillaume@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
