pgvector.git / summary / log / commit / refs

commit    f361bf27048eae3095d04107ba7ebcb221dddda0
Author:   Andrew Kane <andrew@ankane.org>
Date:     Fri Nov 03 23:42:14 2023 +0000

    Improved docs on indexing vectors with different dimensions [skip ci]


README.md | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/README.md b/README.md index 86a074d5..a44aa0e8 100644 --- a/README.md +++ b/README.md @@ -413,7 +413,7 @@ You’ll need to use [dimensionality reduction](https://en.wikipedia.org/wiki/Di #### Can I store vectors with different dimensions in the same column? -You can use the `vector` type (instead of `vector(3)`). However, to index the column, you’ll need to use an [expression](https://www.postgresql.org/docs/current/indexes-expressional.html) to set the number of dimensions and a partial index to filter rows with different dimensions. +You can use the `vector` type (instead of `vector(3)`). However, you can only create indexes on rows with the same number of dimensions (using [partial indexing](https://www.postgresql.org/docs/current/indexes-partial.html) on an [expression](https://www.postgresql.org/docs/current/indexes-expressional.html)). ```sql CREATE INDEX ON items USING hnsw ((embedding::vector(3)) vector_l2_ops) WHERE (model_id = 123); [parent: 3d8c1921aadd]