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 and GIST index methods #1337

Open
robertpang opened this issue May 9, 2019 · 15 comments
Open

[YSQL] Support GIN and GIST index methods #1337

robertpang opened this issue May 9, 2019 · 15 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.

Comments

@robertpang
Copy link
Contributor

robertpang commented May 9, 2019 •
edited by yugabyte-ci
Loading

Jira Link: DB-1851
YugaByte DB currently supports btree and hash index methods only. Consider supporting other index methods:

Index Method Status Comments
GIN In Progress Tracked in #7850
GIST ⬜️
@robertpang robertpang added kind/enhancement This is an enhancement of an existing feature area/ysql Yugabyte SQL (YSQL) labels May 9, 2019
@ddorian ddorian mentioned this issue Jan 27, 2020
Closed
@schoudhury schoudhury changed the title [YSQL] Support additional index methods [YSQL] Support GIN & GIST index methods Feb 27, 2020
@ddorian ddorian mentioned this issue Mar 24, 2020
Open
@Aynn
Copy link

Aynn commented Sep 1, 2020

Aw, this is the one thing preventing me from committing to yugabyte

@ddorian ddorian mentioned this issue Sep 14, 2020
Closed
@rkarthik007 rkarthik007 added the roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list. label Sep 24, 2020
@daniel-yb
Copy link
Contributor

Ran into the need for this trying to run promscale with YB (specifically the need for support for gin indexes).

@airhorns
Copy link

Just want to note another vote for this feature -- would be really amazing, especially when using JSONB fields to get a best-of-both-worlds SQL + NoSQL kind of system going.

@EmiPhil
Copy link

EmiPhil commented Feb 12, 2021

Please!

This and (at least) #997 (exclusion constraint) are required for doing temporal tables sanely. For example a table to track the valid state of a user job table where you want to constrain the user to only have one job_id at any given point in time:

create table temporal (
    user_id text,
    job_id text,
    valid_time tstzrange,
    exclude using gist (user_id with =, job_id with =, vaild_time with &&)
)

@samarpanB
Copy link

Very much in need of this please. How can we get a feature prioritized here ?

@sash2222
Copy link

it will be a cannon. Please prioritize the task! Please.

@Bessonov
Copy link

That's the most voted feature and a one of the blockers to use yb in the current project :(

@m-iancu
Copy link
Contributor

m-iancu commented Apr 22, 2021

GIN indexes are now in-progress and tracked in: #7850
Keeping this open since it includes GiST which will be addressed later.

@Bessonov
Copy link

@m-iancu thank you very much for linking the issue! Does it make sense to rename this issue to GIST index only?

@m-iancu m-iancu changed the title [YSQL] Support GIN & GIST index methods [YSQL] Support GIST index method Apr 22, 2021
@m-iancu m-iancu changed the title [YSQL] Support GIST index method [YSQL] Support GIN and GIST index methods Apr 22, 2021
@m-iancu m-iancu added this to YQL-beta Dec 7, 2021
@manish-a-yadav
Copy link

need this in stable versions.

@ymahajan ymahajan added the pgcm label Feb 14, 2022
@JonasHiltl
Copy link

Any updates to address GIST Indexes in the foreseeable future?

@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 9, 2022
def- added a commit that referenced this issue Aug 23, 2022
@def-
[#13689] YSQL: Improve wording on how to vote on Github issue
4d83d04 
Summary:
There appears to be no way to click on '+' on the description, but in the reactions 👍 appears to be commonly used. Additionally use https://github.com/yugabyte/ instead of https://github.com/YugaByte/ in the links to those issues.

Previously: HINT:  See #1337. Click '+' on the description to raise its priority

Now: HINT:  See #1337. React with thumbs up to raise its priority

Test Plan: Unit tests

Reviewers: mihnea, dmitry, jason

Reviewed By: jason

Subscribers: jason, yql

Differential Revision: https://phabricator.dev.yugabyte.com/D18967
def- added a commit that referenced this issue Aug 24, 2022
@def-
[BACKPORT 2.14][#13689] YSQL: Improve wording on how to vote on Githu…
6fa732c 
…b issue

Summary:
There appears to be no way to click on '+' on the description, but in the reactions 👍 appears to be commonly used. Additionally use https://github.com/yugabyte/ instead of https://github.com/YugaByte/ in the links to those issues.

Previously: HINT:  See #1337. Click '+' on the description to raise its priority

Now: HINT:  See #1337. React with thumbs up to raise its priority

Original commit: 4d83d04 / D18967

Test Plan: Unit tests

Reviewers: mihnea, dmitry, jason

Reviewed By: jason

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D19118
def- added a commit that referenced this issue Aug 24, 2022
@def-
[BACKPORT 2.12][#13689] YSQL: Improve wording on how to vote on Githu…
0343d17 
…b issue

Summary:
There appears to be no way to click on '+' on the description, but in the reactions 👍 appears to be commonly used. Additionally use https://github.com/yugabyte/ instead of https://github.com/YugaByte/ in the links to those issues.

Previously: HINT:  See #1337. Click '+' on the description to raise its priority

Now: HINT:  See #1337. React with thumbs up to raise its priority

Original commit: 4d83d04 / D18967

Test Plan: Unit tests

Reviewers: mihnea, dmitry, jason

Reviewed By: jason

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D19120
def- added a commit that referenced this issue Aug 24, 2022
@def-
[BACKPORT 2.6][#13689] YSQL: Improve wording on how to vote on Github…
1f8c20f 
… issue

Summary:
There appears to be no way to click on '+' on the description, but in the reactions 👍 appears to be commonly used. Additionally use https://github.com/yugabyte/ instead of https://github.com/YugaByte/ in the links to those issues.

Previously: HINT:  See #1337. Click '+' on the description to raise its priority

Now: HINT:  See #1337. React with thumbs up to raise its priority

Original commit: 4d83d04 / D18967

Test Plan: Unit tests

Reviewers: mihnea, dmitry, jason

Reviewed By: jason

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D19123
def- added a commit that referenced this issue Aug 24, 2022
@def-
[BACKPORT 2.8][#13689] YSQL: Improve wording on how to vote on Github…
b7f6593 
… issue

Summary:
There appears to be no way to click on '+' on the description, but in the reactions 👍 appears to be commonly used. Additionally use https://github.com/yugabyte/ instead of https://github.com/YugaByte/ in the links to those issues.

Previously: HINT:  See #1337. Click '+' on the description to raise its priority

Now: HINT:  See #1337. React with thumbs up to raise its priority

Original commit: 4d83d04 / D18967

Test Plan: Unit tests

Reviewers: mihnea, dmitry, jason

Reviewed By: jason

Subscribers: yql

Differential Revision: https://phabricator.dev.yugabyte.com/D19122
@phendric-uk
Copy link

Any updates to support GIST Indexes in the foreseeable future?

@ddorian ddorian mentioned this issue May 12, 2023
Closed
1 task
@alepefe
Copy link

alepefe commented Jul 20, 2023

Any updates yugabyte team?

@efibootmgr
Copy link

Must have feature.

@mattdugganibm
Copy link

Hi, another ask for an update on GIST support - any ETA on that? thanks, Matt.

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) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue roadmap-tracking-issue This issue tracks a major roadmap item, and usually appears in the roadmap list.
Projects
YQL-beta
Status: No status
Milestone
No milestone
Development

No branches or pull requests