Carlos Oliva wrote:
Hi Joshua,
I think that it was installed from a RedHat distribution and the
installation left out reindexdb from the contrib folder. I will look into
this.
In the mean time maybe I can ask you: Does VACUUM FULL ANALYZE of a
database would also reindex the user indexes of a database? I am trying to
eliminate index bloating.
Well on 7.4 vacuum full analyze will deal with part of the problem but
not all. If you are willing to run a full, I would suggest looking into
cluster instead.
Sincerely,
Joshua D. Drake
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 11:27 AM
To: Carlos Oliva
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Reindexdb
Carlos Oliva wrote:
-->
Hi,
Where can I find information about installing and running
contrib/reindexdb? I have searched the manuals and appendixes without
much luck. I just know that there is a contrib for reindexing an entire
database.
We run postgresql (v 7.4.x) in Linux RedHat.
Did you install from source? If so... it is in the source tree under
contrib.
If you are running an RPM it should be in the rpm postgresql-contrib
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
