Once your vector table starts to grow, you will likely want to add an index to speed up queries. Without indexes, you'll be performing a sequential scan which can be a resource-intensive operation when you have many records.
Choosing an index#
pgvector supports two types of indexes:
Indexes can be used to improve performance of nearest neighbor search using various distance measures.
pgvector includes 3 distance operators:
|negative inner product|
Currently vectors with up to 2,000 dimensions can be indexed.
Read more about indexing on
pgvector's GitHub page.