In article <20011012165439.S71408-100000@fw.mccons.net>, Brian McCane wrote:
>
> Being the perpetually lazy person that I am, I have written a PERL script
> that takes care of indexes on a live system. You tell the script the
> database and table to reindex. It then finds a list of indexes for the
> table and creates exactly the same index, with a slightly modified name.
> After the copy is made the old index is DROP'd, and the new one is
> ALTER'd to the old name. Unfortunately, this means that you must have
> enough room for the new index plus the old at the same time, but I am
> sure that most people have lots of spare room. I seem to remember that
> the last time I ran this, it didn't even stop my websites from using the
> tables at the same time. I assume this is because of the versioning
> system used in PostgreSQL.
>
> - brian
>
> Wm. Brian McCane | Life is full of doors that won't open
> Search http://recall.maxbaud.net/ | when you knock, equally spaced amid those
> Usenet http://freenews.maxbaud.net/ | that open when you don't want them to.
> Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
would you consider posting that script or emailing it to me?
It would realy come in handy at work.
Thanks
marc
