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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Joshua D. Drake Sent: Thursday, May 11, 2006 12:01 PM To: Carlos Oliva Cc: pgsql-general@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Joshua D. Drake > Sent: Thursday, May 11, 2006 11:27 AM > To: Carlos Oliva > Cc: pgsql-general@xxxxxxxxxxxxxx > 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
