cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.15k stars 3.81k forks source link

Add Support For btree_gin Extension #51992

Open logston opened 4 years ago

logston commented 4 years ago

Is your feature request related to a problem? Please describe. It would be great to have support for the btree_gin extension.

Describe the solution you'd like Ability to enable the same behavior that is available in PostgreSQL under the extension of the same name.

Describe alternatives you've considered None at the moment. I'm simply showing interest in having this feature available.

Additional context

postgres=# CREATE EXTENSION IF NOT EXISTS btree_gin;
ERROR:  at or near "EOF": syntax error: unimplemented: this syntax
DETAIL:  source SQL:
CREATE EXTENSION IF NOT EXISTS btree_gin
                                        ^
HINT:  You have attempted to use a feature that is not yet implemented.

Please check the public issue tracker to check whether this problem is
already tracked. If you cannot find it there, please report the error
with details by creating a new issue.

If you would rather not post publicly, please contact us directly
using the support form.

We appreciate your feedback.

Jira issue: CRDB-3993

blathers-crl[bot] commented 4 years ago

Hello, I am Blathers. I am here to help you get the issue triaged.

I have CC'd a few people who may be able to assist you:

If we have not gotten back to your issue within a few business days, you can try the following:

:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.

ajwerner commented 1 year ago

Can anybody say more about what value there'd be in adding this extension? We do support inverted indexes. My reading of the docs is that this extension is largely for testing inverted indexes.

pquerna commented 1 year ago

Can anybody say more about what value there'd be in adding this extension? We do support inverted indexes. My reading of the docs is that this extension is largely for testing inverted indexes.

We use btree_gin to support multi-column indexes, exactly in the pattern this blog post outlines:

https://pganalyze.com/blog/gin-index#multi-column-gin-indexes-and-combining-gin-and-b-tree-indexes

CREATE INDEX ON records USING gin (data, customer_id);

Basically we have a tenant/account/customer id which we include in every query, and we also have a JSONB or tsvector we're doing operations against.

tyge68 commented 8 months ago

@ajwerner any update on this, does cockroach db support this extension now ?

rytaft commented 3 weeks ago

[triage] this is a blocker for temporal. used to index a timestamp column?