Shankar, > Is there a better way to do this. comments are > appreciated.
No. This is one of the major features in 7.4; FSM and VACUUM will manage indexes as well. Until then, we all suffer .... BTW, the REINDEX command is transaction-safe. So if your database has "lull" periods, you can run it without worrying that any updates will get turned back. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend