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

Look at and handle potential differences for index types to CockroachDB #12818

Closed
Tracked by #12376
janpio opened this issue Apr 14, 2022 · 2 comments
Closed
Tracked by #12376

Look at and handle potential differences for index types to CockroachDB #12818

janpio opened this issue Apr 14, 2022 · 2 comments
Labels
kind/tech A technical change. team/schema Issue for team Schema. topic: cockroachdb topic: extendedIndexes topic: indexes
Milestone
3.13.0

Comments

@janpio
Copy link
Member

janpio commented Apr 14, 2022 •
edited

CockroachDB is similar to PostgreSQL but not the same.

Is this also the case for index types that we are planning to integrate via #12376? Do we have to differentiate in any way?

Good place to start:
https://www.cockroachlabs.com/docs/stable/indexes.html
https://www.cockroachlabs.com/docs/stable/schema-design-indexes.html
https://www.cockroachlabs.com/docs/stable/create-index.html
https://www.cockroachlabs.com/blog/index-selection-cockroachdb-2/
@janpio janpio mentioned this issue Apr 14, 2022
Closed
33 tasks
@janpio janpio added this to the 3.13.0 milestone Apr 14, 2022
@pimeys
Copy link
Contributor

pimeys commented Apr 19, 2022 •
edited by janpio

Differences based on CDB's answer:

  • Only GiST is supported
  • No special opclasses, so only the ones without should work.

@janpio janpio changed the title Look at potential differences for index types to CockroachDB Look at and handle potential differences for index types to CockroachDB Apr 27, 2022
@pimeys
Copy link
Contributor

pimeys commented Apr 28, 2022

Closing in favor of: #13065

@pimeys pimeys closed this as completed Apr 28, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
kind/tech A technical change. team/schema Issue for team Schema. topic: cockroachdb topic: extendedIndexes topic: indexes
Projects
None yet
Milestone
3.13.0
Development

No branches or pull requests
2 participants
@pimeys @janpio