Reindexing Concurrently
http://www.gavinroy.com/2008/5/9/reindexing-concurrently
Index bloat can be a major pain in heavy OLTP databases. With Reindex being a blocking operation in Postgres, you can not reasonably reclaim index bloat in a large database by hand without going…