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

Allow indexes to opt out of tablegroup. #5293

Closed
vvkgopalan opened this issue Aug 1, 2020 · 0 comments
Closed

Allow indexes to opt out of tablegroup. #5293

vvkgopalan opened this issue Aug 1, 2020 · 0 comments
Assignees
@vvkgopalan
Labels
area/ysql Yugabyte SQL (YSQL)

Comments

@vvkgopalan
Copy link
Contributor

Right now indexes by default follow the tablegroup of the indexed table. Allow at a grammar level for CREATE INDEX to opt an index out of a tablegroup and create its own tablet(s).
@vvkgopalan vvkgopalan self-assigned this Aug 1, 2020
@ddorian ddorian added the area/ysql Yugabyte SQL (YSQL) label Aug 3, 2020
vvkgopalan added a commit that referenced this issue Aug 8, 2020
@vvkgopalan
[#5293][YSQL] Added support for indexes to opt out of tablegroups / s…
3c9ac1a 
…elect their own tablegroup.

Summary:
There are three options now available for index creation with tablegroups:
(1) Index by default follows the tablegroup of its indexed table.
(2) Usage of `NO TABLEGROUP` allows for an index to opt out of the tablegroup of its indexed table and instead create its own tablet(s)
(3) Usage of `TABLEGROUP group_name` allows for the index to be placed in the specified tablegroup, which does not need to be that of its indexed table.

Test Plan:
```
./yb_build.sh --java-test org.yb.pgsql.TestPgRegressTablegroup
```

Reviewers: neha, jason

Reviewed By: jason

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D9077
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vvkgopalan vvkgopalan

Labels
area/ysql Yugabyte SQL (YSQL)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ddorian @vvkgopalan