cockroachdb / cockroachdb/cockroach

sql/vecindex: support vector indexes in metadata tables

Open
#152,101 2 comments 0 reactions 0 assignees View on GitHub
A-vector-index C-enhancement E-quick-win T-specialized-indexing
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

We need to support vector indexes in the SQL metadata tables:

`crdb_internal.table_indexes`: besides adding a row here, the proposal would be to add an `is_vector` boolean column to parallel the existing `is_inverted` boolean column, or maybe something more generalized like `index_details`.

`pg_catalog`: we need to add a row here, with the `pg_am` (access method) column having the value `vector`, to match the existing `prefix`/`inverted` values. We might also consider using `cspann`.

Jira issue: CRDB-53647

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.