Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Phase 2][Post GA][YSQL] Feature: Automatic pull-out of tables from colocation #4396

Open
thinknirmal opened this issue May 5, 2020 · 1 comment
Open

[Phase 2][Post GA][YSQL] Feature: Automatic pull-out of tables from colocation #4396

thinknirmal opened this issue May 5, 2020 · 1 comment
Labels
area/ysql Yugabyte SQL (YSQL) community/request Issues created by external users kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue

Comments

@thinknirmal
Copy link

thinknirmal commented May 5, 2020 •
edited by yugabyte-ci
Loading

Jira Link: DB-559
Would be nice to have a feature that automatically opts-out tables from colocation once they cross a threshold. This would mean that every database could be a colocated database by default, and then tables moving into their own tablets as they grow.

This would push Yugabyte one step further into a truly self-optimising database.
@yugabyte-ci yugabyte-ci added the community/request Issues created by external users label May 5, 2020
@m-iancu m-iancu changed the title Feature: Automatic opt-out of tables from colocation [YSQL] Feature: Automatic opt-out of tables from colocation May 6, 2020
@thinknirmal thinknirmal mentioned this issue May 13, 2020
Open
@ndeodhar ndeodhar changed the title [YSQL] Feature: Automatic opt-out of tables from colocation [YSQL] Feature: Automatic pull-out of tables from colocation May 19, 2020
@rkarthik007 rkarthik007 mentioned this issue Jul 28, 2020
Closed
@bmatican bmatican mentioned this issue Nov 6, 2021
Closed
@m-iancu m-iancu added this to YQL-beta Nov 30, 2021
@tverona1 tverona1 mentioned this issue Apr 27, 2022
Open
@tverona1 tverona1 changed the title [YSQL] Feature: Automatic pull-out of tables from colocation [Phase 2][YSQL] Feature: Automatic pull-out of tables from colocation May 17, 2022
@tverona1 tverona1 added the area/ysql Yugabyte SQL (YSQL) label May 26, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 26, 2022
@tverona1 tverona1 changed the title [Phase 2][YSQL] Feature: Automatic pull-out of tables from colocation [Phase 2][[Post-GA][YSQL] Feature: Automatic pull-out of tables from colocation May 26, 2022
@tverona1 tverona1 changed the title [Phase 2][[Post-GA][YSQL] Feature: Automatic pull-out of tables from colocation [Phase 2][[Post GA][YSQL] Feature: Automatic pull-out of tables from colocation May 26, 2022
@yugabyte-ci yugabyte-ci changed the title [Phase 2][[Post GA][YSQL] Feature: Automatic pull-out of tables from colocation [Phase 2][Post GA][YSQL] Feature: Automatic pull-out of tables from colocation Jun 14, 2022
@yugabyte-ci yugabyte-ci added kind/new-feature This is a request for a completely new feature and removed kind/bug This issue is a bug labels Jul 20, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/new-feature This is a request for a completely new feature labels Aug 18, 2022
@mgrosso
Copy link

mgrosso commented Jan 28, 2023 •
edited
Loading

An application I have in mind with a very large number of tables would only be feasible with this feature, and would be combined with colocation defined at the database and schema levels.

Also needs #4463 or the ability to control the splitting parameters so the schemas colocate out of the database before their larger tables un-colocate themselves.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
area/ysql Yugabyte SQL (YSQL) community/request Issues created by external users kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
YQL-beta
Status: No status
Milestone
No milestone
Development

No branches or pull requests
6 participants
@mgrosso @thinknirmal @m-iancu @tverona1 @ndeodhar @yugabyte-ci