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:
- Engage the settings on Enterprise manager
- Uncheck "Analyze database tables during data collection". You will need to stop the collector to be able to uncheck the box.