From: Guillaume Lelarge <guillaume@lelarge.info>
To: Laszlo Nagy <gandalf@shopzeus.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Big index sizes
Date: Tue, 30 Dec 2008 10:21:11 +0100
Message-ID: <4959E807.1090107@lelarge.info> (raw)
In-Reply-To: <4959E477.9050700@shopzeus.com>
References: <4959E477.9050700@shopzeus.com>
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.orghttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: guillaume@lelarge.info, gandalf@shopzeus.com
Subject: Re: Big index sizes
In-Reply-To: <4959E807.1090107@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox