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

[YSQL] Support GIN indexes for tsvector values #9955

Open
jaki opened this issue Sep 9, 2021 · 0 comments
Open

[YSQL] Support GIN indexes for tsvector values #9955

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

Comments

@jaki
Copy link
Contributor

jaki commented Sep 9, 2021 •
edited by yugabyte-ci
Loading

Jira Link: DB-2230
@jaki jaki added kind/new-feature This is a request for a completely new feature area/ysql Yugabyte SQL (YSQL) labels Sep 9, 2021
@jaki jaki self-assigned this Sep 9, 2021
@jaki jaki mentioned this issue Sep 9, 2021
Open
26 tasks
jaki added a commit that referenced this issue Oct 27, 2021
@jaki
[#9955] ysql: support ybgin prefix match
d9bcad0 
Summary:
Implement prefix matching for ybgin index key type text by using
`make_greater_string` to construct a between operator to pass to DocDB.
Since that function is not guaranteed to work for non-C collations,
error when encountering non-C collations.  The implementation is similar
to that of `textcolumn LIKE 'abc%'`, and it is not similar to what is
done in upstream postgres GIN's `tsCompareString`, which more directly
looks for matching prefix.

This ultimately supports queries like

    SELECT ... WHERE tsvectorcolumn @@ to_tsquery('simple', 'abc:*');

on ybgin index.

Depends on D11274

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

Reviewers: neil, amartsinchyk, mihnea

Reviewed By: amartsinchyk, mihnea

Subscribers: mihnea, mtakahara, yql

Differential Revision: https://phabricator.dev.yugabyte.com/D12275
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 9, 2022
@yugabyte-ci yugabyte-ci assigned jasonyb and unassigned jaki Jul 9, 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jasonyb jasonyb

Labels
area/ysql Yugabyte SQL (YSQL) 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
4 participants
@tverona1 @jaki @yugabyte-ci @jasonyb