Skip to main content

Maximum number tables

  • Nov 28, 2018 3:19 AM UTC
  • 3 replies
  • 15 views
Kaito
Forum|alt.badge.img+2
  • Kaito
  • Participating Frequently

Hi team,

I would like to create 10,000 tables at Vertica cluster. Does Vertica support this scale of tables?

    3 replies

    DaveT
    Forum|alt.badge.img
    • DaveT
    • Participating Frequently
    • Nov 28, 2018 3:46 AM UTC
    If your catalog directory is on a separate file system then ensure it has enough space. Main thing to monitor is memory. Your catalog is going to consume more memory and you want to ensure you have enough left to satisfy your query workload.
    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • Nov 28, 2018 3:48 AM UTC

    Based on the documentation number of tables per database is limited by physical RAM, as the catalog must fit in memory.

    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemLimits.htm?tocpath=SQL Reference Manual|_____2

    Kaito
    Forum|alt.badge.img+2
    • Kaito
    • Author
    • Participating Frequently
    • Nov 28, 2018 4:06 AM UTC

    Thank you, Dave and Sruthi!

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement