Skip to main content

catalog size

  • December 9, 2017
  • 1 reply
  • 8 views
naresh_way2
Forum|alt.badge.img+1

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

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • December 10, 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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement