Is there any way to reduce catalog size?

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?

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