Index Creation
Creating a HNSW Index
An HNSW index can be created over any column with the vector type.
Vectors with up to 2,000 dimensions can be indexed.
CREATE INDEX ON <schema_name>.<table_name>
USING hnsw (<column_name> <distance_metric>);
The name of the schema, or namespace, of the table. If not provided, the search path is used as a default.
The name of the table being indexed.
The name of the column being indexed. Must be of type vector.
The distance metric used for measuring similarity between two vectors. Use
vector_l2_ops for L2 distance, vector_ip_ops for inner product, and
vector_cosine_ops for cosine distance.
Index Options
The following example demonstrates how to pass options when creating the HNSW index:
CREATE INDEX ON mock_items
USING hnsw (embedding vector_l2_ops)
WITH (m = 16, ef_construction = 64);
The maximum number of connections per layer. A higher value increases recall but also increases index size and construction time.
A higher value creates a higher quality graph, which increases recall but also construction time.
Deleting a HNSW Index
The following command deletes a HNSW index:
DROP INDEX <index_name>;
The name of the index you wish to delete.
Recreating a HNSW Index
An HNSW index only needs to be recreated if the name of the indexed column changes. To recreate the index, simply delete and create it using the SQL commands above.
Was this page helpful?