Performance issues with POM server

Last Updated : Jun 03, 2026 |

Problem description

You might experience some performance issues with the POM server or Supervisor Dashboard takes time to load. The system might show large amounts of disk space utilization for the POM Postgres database. The system might take time to load the POM pages.

Proposed solution

Procedure

  1. Run the following query and verify the output of the query. 
    SELECT
    table_name,
    pg_size_pretty(table_size) AS table_size,
    pg_size_pretty(indexes_size) AS indexes_size,
    ratio
FROM (
    SELECT
        table_name,
        pg_table_size(table_name) AS table_size,
        pg_indexes_size(table_name) AS indexes_size,
        CASE WHEN pg_table_size(table_name) = 0   THEN 2
			ELSE (pg_indexes_size(table_name) / pg_table_size(table_name)) END as ratio          
    FROM (
        SELECT ('"' || table_schema || '"."' || table_name || '"') AS schema_table_name,
        table_name as table_name
        FROM information_schema.tables where table_name like 'pim_%'
    ) AS all_tables where pg_indexes_size(table_name) > 1024*1024*100
    ORDER BY indexes_size DESC
) AS pretty_sizes where ratio >=2 order by ratio desc
  2. If the query returns the table size and index size, and you notice a considerable increase in the size of the database in some GBs of space, run reindexPOMPGDB.sh script from $POM_HOME/bin.
    Note:

    Run the reindexPOMPGDB.sh script under the maintenance window.