Vacuum Postgres

Document ID:KM03709685
Creation Date:16-Sep-2020
Modified Date:16-Sep-2020
- Micro Focus Products:
  operations bridge reporter 10.30

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Vacuum Postgres

Error

To increase Postgres performance

Fix

1. Stop Collection, Orchistration, IM,Timer, JobManager and TaskManager
2. in Command line:
cd %HPE-OBR%\PMDB\scripts
mgmtsqlexecutor -sqlscript vacuum_postgres.sql

Fro Linux:

1. Need to run Postgres Vaccum, run the below command for postgres Vaccum with pmdb_admin credentials
vacuumdb --host=<OBR hostname> --port=21425 --dbname=dwabc --username=pmdb_admin --analyze --verbose

2. Need to Increase Virtual Memory of OBR server.
Edit catalina.sh of JAVA_OPTS in $PMDB_HOME/adminServer/bin

set the parameter -Xmx640m to -Xmx2048m