search

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
29.89k stars 3.77k forks source link

sql: Support GIST/SPGIST indexes #41292

Open rohany opened 4 years ago

rohany commented 4 years ago

Postgres has support for GIST and SPGIST indexes https://www.postgresql.org/docs/current/indexes-types.html, https://www.postgresql.org/docs/current/sql-createindex.html, which is unsupported right now. These are used in the Django test suite.

Jira issue: CRDB-5463

petermattis commented 4 years ago

@rohany Can you elaborate on how they are used? Support GiST and SP-GiST is a non-starter from my understanding of how they work.

rohany commented 4 years ago

As of now they are just used in some tests in the django test suites (some tests just want to create GIST indexes). We are going through and triaging the test failures, so I just wanted to have an issue tracking these to blacklist tests in the future.

github-actions[bot] commented 3 years ago

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 5 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB!

aep commented 2 years ago

They're used in indexing ranges

rytaft commented 1 year ago

cc @awoods187 for awareness

dikshant commented 1 year ago

This is a low priority from SQL Sessions perspective. We haven't seen any specific asks around using this indexes through Django.