Laszlo Nagy a écrit :
> We have serveral table where the index size is much bigger than the
> table size.
> 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?)
In response to
pgsql-performance by date
|Next:||From: Anton Bogdanovitch||Date: 2008-12-30 10:41:42|
|Subject: perform 1 check vs exception when unique_violation|
|Previous:||From: Laszlo Nagy||Date: 2008-12-30 09:05:59|
|Subject: Big index sizes|