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