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] ReindexdbCarlos 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] ReindexdbCarlos 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?
"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