Skip to main content

How many maximum databases or tables is recommended in a ClickHouse cluster?

· One min read

We recommend having a maximum of 100 databases and 1000 tables across all databases for a Service. Databases in ClickHouse are more of a namespace and have no performance impact, so 100 databases is a loose guideline. However, the number of tables would affect the Service startup time, so we recommend limiting the number of tables or partitions.