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.


Vacuum Postgres


To increase Postgres performance


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 of JAVA_OPTS in $PMDB_HOME/adminServer/bin
set the parameter  -Xmx640m to -Xmx2048m