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
