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.

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

[YSQL] Support multicolumn GIN indexes #10652

Open
jaki opened this issue Nov 19, 2021 · 1 comment
Open

[YSQL] Support multicolumn GIN indexes #10652

jaki opened this issue Nov 19, 2021 · 1 comment
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects

Comments

@jaki
Copy link
Contributor

jaki commented Nov 19, 2021

Jira Link: DB-892

@jasonyb jasonyb added the area/ysql Yugabyte SQL (YSQL) label Nov 19, 2021
@jasonyb jasonyb added this to To do in GIN Indexes via automation Nov 19, 2021
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@jasonyb
Copy link
Contributor

jasonyb commented Jul 19, 2022

Currently, amroutine->amcanmulticol = false. This means that gin indexes can only index a single column, not multiple columns. There's also amroutine->amcaninclude = false, but that is a limitation with upstream postgres as well.

Note that the btree_gin extension is most useful with multicolumn because it allows gin indexed columns to be alongside regular indexed columns.

keywords: multi-column multi column btree btreegin btree_gin btree-gin extension

@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
Status: No status
Development

No branches or pull requests

5 participants