PostgreSQL index management in production systems

Its often tedious task to work with production databases. A small mistake could be a disastrous. This article is to refresh the memory on how to manage the indexes in the PostgreSQL production systems.