Hi team,
I would like to create 10,000 tables at Vertica cluster. Does Vertica support this scale of tables?
Maximum number tables
+2
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.
+1Based on the documentation number of tables per database is limited by physical RAM, as the catalog must fit in memory.
+2Thank you, Dave and Sruthi!
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
