Re: Reindexdb

Thank you again Joshua.

Perhaps I can ask you another question: How does the VACUUM FULL ANALYZE
differ from a reindex? A VACUUM FULL ANALYZE is outputting messages about
pages recuperated for indexes. Hence I was under the impression that
obsolete index pages were recuperated by the VACUUM FULL ANALYZE.

Clustering could be tricky for me because in my multi-developer environment,
I will have difficulty controlling which indexes are deleted and created.

-----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 12:01 PM
To: Carlos Oliva
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq