Re: [GENERAL] Contrib: Reindex script.

Sorry, this is the actual version I applied.

---------------------------------------------------------------------------

Shaun Thomas wrote:
> Ok,
>
> As before, this script is basically a vacuumdb for indexes.  I call it
> reindexdb on my own system, and put it in the postgres binary directory
> simply because it's indispensable in my system.
>
> This should be the last one.  Someone complained that assuming that the
> script will reside in the same directory as psql was silly.  That's
> true, though eventually I'd like to see this, or a utility like it,
> included in the official postgres distribution.
>
> The script now uses various tricks to figure out where psql is.
> Starting with path, continuing with the directory the script is in,
> then whereis, and finally locate.  These are arranged in order of speed
> so it can find psql as fast as possible.  Even so, the full iteration
> through all methods takes less than a second.
>
> If your system doesn't have whereis or locate, I've directed output from
> all of these search commands to /dev/null so these tests will simply
> fail if the command is unavailable.
>
> Use, and enjoy.
>
> --
> +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
> | Shaun M. Thomas                INN Database Administrator           |
> | Phone: (309) 743-0812          Fax  : (309) 743-0830                |
> | Email: sthomas@townnews.com    AIM  : trifthen                      |
> | Web  : www.townnews.com                                             |
> |                                                                     |
> |     "Most of our lives are about proving something, either to       |
> |      ourselves or to someone else."                                 |
> |                                           -- Anonymous              |
> +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026