Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

catalog size

Hi,
Can any body explain me how to reduce catalog size in vertica. Because it effects my query performance a lot.

Comments

  • Jim_KnicelyJim_Knicely Administrator
    edited December 2017

    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":

    1. Database, nodes, schemas, tables, views, projections
    2. Users, profiles, roles, grants
    3. Epochs
    4. Resource Pools

    While these objects affect the "Local Catalog" size:

    1. ROS containers
    2. Delete Vectors
    3. WOS
    4. Statistics

    A large number of objects can increase the catalog size, but the biggest factors that contribute to a large catalog are:

    1. Too many ROS containers
      1a. Incorrectly defined ActivePartitionCount
      2b. Local Segmentation – with a high scaling factor

    2. A large number of Partitions

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.