Обсуждение: Reindexdb
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.
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/
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
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@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/
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@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Thursday, May 11, 2006 12:01 PM
To: Carlos Oliva
Cc: pgsql-general@postgresql.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@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 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
"Carlos Oliva" <carlos@pbsinet.com> writes:
> 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.
VACUUM FULL not only doesn't do a REINDEX for you, it's more likely to
bloat the indexes than shrink them.
regards, tom lane
Thank you Tom. I will look at reindexing the database