Re: Reindexdb - Mailing list pgsql-general

From Carlos Oliva
Subject Re: Reindexdb
Date
Msg-id 200605111557.LAA02919@pbsi.pbsinet.com
Whole thread Raw
In response to Re: Reindexdb  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Reindexdb  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Reindexdb  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 11:27 AM
To: Carlos Oliva
Cc: pgsql-general@postgresql.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@postgresql.org so that your
       message can get through to the mailing list cleanly



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Reindexdb
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Reindexdb