Laszlo Nagy a écrit : > We have serveral table where the index size is much bigger than the > table size. > > Example: > > select count(*) from product_price -- 2234244 > > Table size: 400 MB > Index size: 600 MB > > After executing "reindex table product_price", index size reduced to 269MB. > > I believe this affects performance. > > Vacuuming a table does not rebuild the indexes, am I right? Neither VACUUM nor VACUUM FULL rebuild the indexes. CLUSTER and REINDEX do. > I'm not sure > if I need to do this manually, or is this the result of another problem? You need to do this manually. > (For example, too many open transactions, frequent updates?) > Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
