In article <[EMAIL PROTECTED]>, 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 [EMAIL PROTECTED])
would you consider posting that script or emailing it to me? It would realy come in handy at work. Thanks marc ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
