We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


catalog size — Vertica Forum

catalog size

naresh_way2naresh_way2
in General Discussion

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 - Select Field - 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...