Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

No ratings
Showing results for 
Search instead for 
Did you mean: 

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

Last Update:

Aug 12, 2021 8:23:19 AM

Updated By:


Created date:

Aug 12, 2021 8:23:19 AM

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.


  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: