Re: Reindexdb

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.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 11:27 AM
To: Carlos Oliva
Cc: pgsql-general(at)postgresql(dot)org
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/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly