Hi, Can any body explain me how to reduce catalog size in vertica. Because it effects my query performance a lot.
Check out the blog post "Troubleshooting Tips for the Vertica Catalog":https://my.vertica.com/kb/TroubleshootingTipsfortheVerticaCatalog/Content/BestPractices/TroubleshootingTipsfortheVerticaCatalog.htm
The following objects affect the size of the "Global Catalog":
While these objects affect the "Local Catalog" size:
A large number of objects can increase the catalog size, but the biggest factors that contribute to a large catalog are:
Too many ROS containers 1a. Incorrectly defined ActivePartitionCount 2b. Local Segmentation – with a high scaling factor
A large number of Partitions
Comments
Check out the blog post "Troubleshooting Tips for the Vertica Catalog":
https://my.vertica.com/kb/TroubleshootingTipsfortheVerticaCatalog/Content/BestPractices/TroubleshootingTipsfortheVerticaCatalog.htm
The following objects affect the size of the "Global Catalog":
While these objects affect the "Local Catalog" size:
A large number of objects can increase the catalog size, but the biggest factors that contribute to a large catalog are:
Too many ROS containers
1a. Incorrectly defined ActivePartitionCount
2b. Local Segmentation – with a high scaling factor
A large number of Partitions