Postgres Not Vacuuming properly and dsp parameters
search cancel

Postgres Not Vacuuming properly and dsp parameters

book

Article ID: 264625

calendar_today

Updated On:

Products

Mainframe Operational Intelligence

Issue/Introduction

Postgres is not vacuuming properly.   As a work-around, users can remove the underlying data for Postgres and going through the re-learn process. Then monitor the new instance to see if the vacuuming process properly vacuums itself up after the daily model build process.  What else can be done to tune the DSP parameters for the Postgres database?

Environment

Release : 2.1

Resolution

Attached to this document is a PFA script which can tune DSP to reduce the load on the Postgresql Database.

Steps to run the script dsp_disable_pg_save.sh:
-  Copy the attached script to the target MOI system
-  Run it:  sh dsp_disable_pg_save.sh

Note:  To confirm the change is applied with script "dsp_disable_pg_save.sh" correctly, run the following command:
docker exec -it dsp_dsp_1 cat /opt/CA/itoa/dsp/dsp.env | grep KDE_BUILD_GH

 

Attachments

1682368375005__dsp_disable_pg_save.sh get_app