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