Cisco Cisco Prime Data Center Network Manager 6.1 Troubleshooting Guide
Document ID: 118414
Updated: Sep 28, 2015
Contributed by Eric Scott, Cisco TAC Engineer.
Related Products
●
Contents
IntroductionBackground InformationVacuum DCNM's Postgresql Database in WindowsVacuum DCNM's Postgresql Database in LinuxConfigure Autovacuum for Postgres DatabaseRelated Cisco Support Community Discussions
Introduction
This document describes how to vacuum the postgres database in Microsoft Windows and Linux.
Background Information
It is absolutely critical to vacuum postgres databases in order for the databases to properly
function. Through the life of the database, new entries are added and current entries are updated.
By design, postgres does not immediately remove the iterations of a record as it gets updated.
Therefore, postgres databases can contain a large number of stale, unused records. These old
records should be removed at least every two weeks with the vacuum function in order to reduce
disk usage and improve the speed of database queries. It is even more effective if you configure
postgres to automatically vacuum the database without the need to stop the Data Center Network
Manager (DCNM) services.
function. Through the life of the database, new entries are added and current entries are updated.
By design, postgres does not immediately remove the iterations of a record as it gets updated.
Therefore, postgres databases can contain a large number of stale, unused records. These old
records should be removed at least every two weeks with the vacuum function in order to reduce
disk usage and improve the speed of database queries. It is even more effective if you configure
postgres to automatically vacuum the database without the need to stop the Data Center Network
Manager (DCNM) services.
Note: $INSTALLDIR throughout this article refers to "C:\Program Files\Cisco Systems\" or
"/usr/local/cisco/" based on the operating system, Microsoft Windows or Linux respectively.
The install path could be changed from these defaults during installation.
"/usr/local/cisco/" based on the operating system, Microsoft Windows or Linux respectively.
The install path could be changed from these defaults during installation.