From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian McCane <bmccane@mccons.net>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: VACUUM FULL
Date: Sun, 12 May 2002 11:22:28 -0400
Message-ID: <29763.1021216948@sss.pgh.pa.us> (raw)
In-Reply-To: <20020511120040.X12454-100000@fw.mccons.net>
References: <20020511120040.X12454-100000@fw.mccons.net>
Brian McCane <bmccane@mccons.net> writes:
> Would I possibly see another performance boost if I rebuilt the
> indexes involved like I used to in 7.1.3? I still have the Perl script
> sitting around here some place, but assumed from things said by you and
> Bruce in the past few months about 7.2.x that it wouldn't be necessary
> anymore. I guess I'll give it a try this weekend and see what happens.
An occasional index rebuild (using either REINDEX or DROP/CREATE INDEX)
is still worth doing for heavily updated tables, especially if the range
of indexed values changes over time. That'll remain true until someone
gets around to teaching btree indexes how to collapse out free space...
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, bmccane@mccons.net
Subject: Re: VACUUM FULL
In-Reply-To: <29763.1021216948@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