From: Tom Lane <tgl@sss.pgh.pa.us>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: 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:39:21 -0500
Message-ID: <15381.1230651561@sss.pgh.pa.us> (raw)
In-Reply-To: <4959E807.1090107@lelarge.info>
References: <4959E477.9050700@shopzeus.com>
<4959E807.1090107@lelarge.info>
Guillaume Lelarge <guillaume@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.
In fact, VACUUM FULL tends to make indexes *more* bloated not less so.
One fairly likely explanation for how you got into this situation is
overeager use of VACUUM FULL.
regards, tom lane
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: tgl@sss.pgh.pa.us, guillaume@lelarge.info, gandalf@shopzeus.com
Subject: Re: Big index sizes
In-Reply-To: <15381.1230651561@sss.pgh.pa.us>
* 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