Run the reindexPOMPGDB.sh script from the $POM_HOME/bin folder.
Note:
The reindexPOMPGDB.sh script is applicable only for Postgres database. For Oracle and MS SQL Server database, see the respective help topic, or contact the database administrator to re-index the database.
This script indexes all tables created by POM.
Run the script when queries to the database take long time, as a result of which you cannot open Supervisor Dashboard or Supervisor Dashboard does not display the data quickly.
Tip:
Run the reindexPOMPGDB.sh script under the maintenance window.
The frequency of reindexing the tables is dependent on the volume of data used by the POM system. Based upon your requirements and amount of data, you can schedule to run the script using the cron tab to run on periodic basis during off peak hours. Running the script does not impact running campaigns.
