Verifying Catalog Memory Consumption
Vertica 9.2 significantly reduces how much memory database catalogs consume. After you upgrade, check catalog memory consumption on each node to verify that the upgrade refactored catalogs correctly. If memory consumption for a given catalog is as large as or larger than it was in the earlier database, restart the host node.
Certain operations might significantly inflate catalog memory consumption. For example:
- You created a backup on a 9.1.1 database and restored objects from the backup to a new 9.2 database.
- You replicated objects from a 9.1.1 database to a 9.2 database.
To refactor database catalogs and reduce their memory footprint, restart the database.