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@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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
