PostgreDB performance issues

  • KM03652830
  • 18-Jun-2020
  • 17-Jul-2020

Summary

How we can improve performance of PostgreDB.

Error

Streams start slow or stop starting.

Cause

Possible is that we need to increase PostgreDB performance.

Fix

1. Stop the Collection, Orchestration services

2. Please run this below command, this will increase the postgres performance
 $PMDB_HOME/bin/mgmtsqlexecutor -sqlscript $PMDB_HOME/scripts/vacuum_postgres.sql -logfile $PMDB_HOME/temp/postgresql_vacuum.log

3. Start services