We are having 3 node cluster and catalog size is 5% occupied of total memory. Is there any way to clear it?
If your Vertica version is above 8.0.1 try this to see the memory used by the in-memory catalog
before you stop the DB and after you start it.
select memory_size_actual_kb from resource_pool_status where pool_name='metadata';
What Version of Vertica are you using ? The catalog size in 9.2.1 is reduced by a lot because we changed the way that we make reference to the storage containers.
In addition to reduce the catalog size it is important to figure it out why the catalog is big. This document should give you some tips https://www.vertica.com/kb/TroubleshootingTipsfortheVerticaCatalog/Content/BestPractices/TroubleshootingTipsfortheVerticaCatalog.htm
Hope this helps.
Since I have checked my Checkpoint and Transaction folder and it has only 100 MB Size. So is there more way to clean up the catalog size?
Or by restarting the node it will automatically reduce the size?