Is there any way to reduce catalog size?
hsaxena20
Community Edition User
We are having 3 node cluster and catalog size is 5% occupied of total memory. Is there any way to clear it?
0
Best Answer
-
mosheg
Vertica Employee Administrator
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';
5
Answers
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.
Eugenia
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?