> 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 

-Josh Berkus
 Aglio Database Solutions
 San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to