Skip to content

Question about Index Creation on Embedding and Column #23

@jarredSafegraph

Description

@jarredSafegraph

Howdy, I am curious if you might elaborate on how indexes are created and queried when using an embedding and another column like in the below example. At the moment, I believe, with pgvector, there is no way to create an index on an embedding and column.

This thread in pgvector notes that it the current approach may be using a partial index but with many values in a column, that is not very feasible.

CREATE INDEX my_remote_index ON products USING pinecone (embedding, price) with (host = 'my-pinecone-index.pinecone.io');

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions