Is there any way to reduce catalog size?

hsaxena20

We are having 3 node cluster and catalog size is 5% occupied of total memory. Is there any way to clear it?

mosheg

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';

emoreno

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

hsaxena20

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?