Re: Reindexdb

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(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/