Skip site navigation (1) Skip section navigation (2)

Re: Big index sizes

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Big index sizes
Date: 2008-12-30 09:21:11
Message-ID: 4959E807.1090107@lelarge.info (view raw or flat)
Thread:
Lists: pgsql-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 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

In response to

Responses

pgsql-performance by date

Next:From: Anton BogdanovitchDate: 2008-12-30 10:41:42
Subject: perform 1 check vs exception when unique_violation
Previous:From: Laszlo NagyDate: 2008-12-30 09:05:59
Subject: Big index sizes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group