[Docs] Title for ysql, does creating more databases help with partitioning or creating more tables help?

[hiqsociety]

Description

[Docs] Title for ysql, does creating more databases help with partitioning or creating more tables help?

possible to show how the internal mechanism of YSQL layer works?

at petabyte scale db, what's the performance impact of splitting up YSQL data into more db shards or more tables?

Warning: Please confirm that this issue does not contain any sensitive information

• [X] I confirm this issue does not contain any sensitive information.

[ddorian]

Hi @hiqsociety

The "sharding" mechanism is at the "tablet" layer. So a single table split into tablets, can grow to a petabyte level.

You don't need partitioning or multiple databases (though they may help or not depending on the exact scenario).

at petabyte scale db, what's the performance impact of splitting up YSQL data into more db shards or more tables?

The splitting is done at each tablet separately.

Please read the architecture section: https://docs.yugabyte.com/stable/architecture/

Mainly:

1. https://docs.yugabyte.com/stable/architecture/design-goals/
2. https://docs.yugabyte.com/stable/architecture/docdb-sharding/
3. https://docs.yugabyte.com/stable/architecture/concepts/yb-tserver/
4. https://docs.yugabyte.com/stable/architecture/core-functions/
5. https://docs.yugabyte.com/stable/architecture/docdb/

[ddorian]

Closing as no reply from user.