Vacuum Postgres

  • KM03709685
  • 16-Sep-2020
  • 16-Sep-2020

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