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 ASC/DESC/HASH on GIN indexes #10653

Open
jaki opened this issue Nov 19, 2021 · 0 comments
Open

[YSQL] Support ASC/DESC/HASH on GIN indexes #10653

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

Comments

@jaki
Copy link
Contributor

jaki commented Nov 19, 2021

Jira Link: DB-987

Description

GIN indexes currently do not support user-supplied ASC/DESC/HASH on index column. They default to ASC because that's what enables tsvector prefix match to work. But this isn't relevant if users don't care about tsvector prefix match.

Allow ASC/DESC/HASH to be used on GIN indexes. It should have no consequences when done on types like arrays or jsonbs. Even for tsvector, if there's a way to figure out and resort to full scan in case the index is HASH and is using prefix match, then that works.

@jaki jaki added the area/ysql Yugabyte SQL (YSQL) label Nov 19, 2021
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@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

4 participants