Re: Big index sizes

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