Maximum number tables

Kaito

Hi team,

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

DaveT

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

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

Thank you, Dave and Sruthi!