Table partitioning is a must have for large databases, allowing to split data according a list of values or by a range.
Describe the solution you'd like
Several databases support table partitioning, and PostgreSQL, CockroachDB and YugabyteDB are among them.
This feature allow great control about data distribution among splitted tables.
For example, someone could have a logs table with range by date, and then it's possible to delete records with more than 180 days just by dropping the corresponding partition. There lots of more use cases for partitioning (like transfer data to slower - and cheaper - disks when the partition becomes obsolete (like moving to DuckDB/Parquet files at s3).
Additional context
PostgreSQL documentation: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARMS-PARTITION-BY
CockroachDB documentation: https://www.cockroachlabs.com/docs/v25.2/partitioning
Oracle documentation: https://www.oracle.com/database/technologies/partitioning.html
MySQL documentation: https://dev.mysql.com/doc/refman/9.0/en/partitioning-overview.html
Table partitioning is a must have for large databases, allowing to split data according a list of values or by a range.
Describe the solution you'd like
Several databases support table partitioning, and PostgreSQL, CockroachDB and YugabyteDB are among them.
This feature allow great control about data distribution among splitted tables.
For example, someone could have a logs table with range by date, and then it's possible to delete records with more than 180 days just by dropping the corresponding partition. There lots of more use cases for partitioning (like transfer data to slower - and cheaper - disks when the partition becomes obsolete (like moving to DuckDB/Parquet files at s3).
Additional context
PostgreSQL documentation: https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARMS-PARTITION-BY
CockroachDB documentation: https://www.cockroachlabs.com/docs/v25.2/partitioning
Oracle documentation: https://www.oracle.com/database/technologies/partitioning.html
MySQL documentation: https://dev.mysql.com/doc/refman/9.0/en/partitioning-overview.html