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.
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
On Tue, Dec 30, 2008 at 4:05 AM, Laszlo Nagy gand...@shopzeus.com wrote:
We have serveral table where the index size is much bigger than the table
size.
You'll usually get index bloat in roughly the same measure that you
get table bloat. If you always (auto)vacuum regularly, then the
amount of
Guillaume Lelarge guilla...@lelarge.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.