cockroachdb / cockroachdb/docs

Feedback: Database Schemas - perhaps incorrect/unhelpful guidance on large number of schemas

Open
#19,624 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
212
Forks
476
Avg merge
40m
Merged PRs (30d)
3

Description

Page: https://cockroachlabs.com/docs/v25.2/schema-design-overview.html

## What is the reason for your feedback?

[ ] Missing the information I need

[ ] Too complicated

[ ] Out of date

[ ] Something is broken

[X] Other

## Additional details

The page says

> The number of databases or schemas on the cluster has minimal impact on the total number of tables that it can support.

This implies that a CockroachDB cluster can support a large number of schemas, which is not the case. Please consult with the engineering team to reword this in a way that more accurately reflects the impact of large numbers of non-table objects, including schemas. Anecdotally, I have heard that CockroachDB has problems with a large total number of object descriptors, rather than the numbers of specific types of database objects.

Note that different subsystems may be impacted differently. So, for example, query performance may be acceptable but other database components, such as the DB Console or backups, may fail or perform poorly.

As a specific example for schemas, performed a simple test. I created 20000 schemas on a CockroachDB cluster. SQL queries against tables in these schemas seemed to perform fine, but a SHOW SCHEMAS query took an extremely long time to run.

THANK YOU

Jira issue: DOC-13736

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.