From: Jeffrey A. Rhines <jrhines@email.com>
To: pgsql-general@postgresql.org
Subject: Re: Need for rebuilding index after many deletions?
Date: Fri, 04 Aug 2000 12:51:14 -0500
Message-ID: <398B0292.A16EDF00@email.com> (raw)
References: <00bf01bffb93$dd3f4a20$d565e2c1@vs>
<20000804162632.A2137@feivel.credativ.de>
<398AE87D.8D1A913@fa.disney.com>
If you're worried about performance, a vacuum should do the trick,
right?
Jeff
Patrick Robin wrote:
>
> Hi all,
>
> With Postgres 6.5.2, if a table has undergone several row deletions,
> does it make sense/ is it needed to rebuild the index? Would this be
> accomplished by
> dropping it and then recreating it?
>
> Thanks
>
> Patrick
>
> --
> ________________________________________
> Patrick Robin
> patrickr@fa.disney.com
> Walt Disney Feature Animation
> 500 South Buena Vista Street
> Burbank,California 91521-4817
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-interfaces@postgresql.org
Cc: jrhines@email.com, pgsql-general@postgresql.org
Subject: Re: Need for rebuilding index after many deletions?
In-Reply-To: <398B0292.A16EDF00@email.com>
* 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