Micro Focus Email

Send E-mail

Self-Solve Knowledge Search

PostgreDB performance issues

PostgreDB performance issues

PostgreDB performance issues

PostgreDB performance issues
B-SL:100 HPSL:100 LIB4:false TYPE:errormsg HPTYPE:technical_documents ATT:0

Summary

How we can improve performance of PostgreDB.

Problem

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

Additional Information

Was this document helpful? Feedback