The ITBM standard appliance has it’s own local database. Behind the scenes it is running a vPostgres database to store information about cost and consumptions of your private and public cloud. Over time the database tables can become fragmented and impact performance. Always snapshot or backup your appliance before attempting this procedure. NOTE: This procedure is not currently supported by VMware. Use at your own risk.
1. Login to vCenter and take a snapshot of your ITBM appliance VM.
2. Login to the ITBM appliance as root and change directory to /opt/vmware/vpostgres/current/bin/
3. Type: ./reindexdb –dbname postgres –username itfm_cloud_admin and press enter
./reindexdb --dbname postgres --username itfm_cloud_admin
3.1 You should see a bunch of Notices like the following screen indicating which tables were reindexed. NOTE: It may take a minute or two.
4. If you want to run this on a regular schedule, create a shell file named reindexitbmdb.sh with the following lines and save it
cd /opt/vmware/vpostgres/current/bin/ ./reindexdb --dbname postgres --username itfm_cloud_admin