Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW

How to control "Vacuum" on Postgres backend for Enterprise Manager

cancel
Showing results for 
Search instead for 
Did you mean: 
Ted_Manka
Support
Support

How to control "Vacuum" on Postgres backend for Enterprise Manager

Enterprise manager uses Postgres as a backed for tracking statistics of the servers that it connects to.   Postgres needs to perform a "Vacuum" operation from time to time:

" In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM is done. Therefore it's necessary to do VACUUM periodically, especially on frequently-updated tables."

Enterprise manager under normal circumstances will take care of initiating the vacuum process.  There may be times when you would not want Enterprise Manager to kick off the vacuum process.  This may include running Postgres on a managed instance (where the vacuuming is done for you) or a shared instance of Postgres where there are other operations running on Postgres. 

To prevent Enterprise Manager from initiating the vacuum  process you will need to uncheck the "Analyze database tables during data collection" inside the analytics configuration section of the settings.

Steps:

  1. Engage the settings on Enterprise managerTed_Manka_0-1628770844448.png
  2. Uncheck "Analyze database tables during data collection".  You will need to stop the collector to be able to uncheck the box.Ted_Manka_1-1628770946900.png

     

 

 

Tags (2)
Version history
Last update:
‎2021-08-12 08:23 AM
Updated by:
Contributors