pgvector

pg vector github

• Postgresql을 vector database처럼 사용할 수 있게 해주는 Extension
• vector라는 type이 추가됨
• vector로 vector similarity 연산을 지원

Install

• linux & mac

cd /tmp
git clone --branch v0.8.1 https://github.com/pgvector/pgvector.git
cd pgvector
make
make install # may need sudo

사용법

• extension 적용

  CREATE EXTENSION vector;
  

• 추가되는 연산자
  • <-> - L2 distance
  • <#> - (negative) inner product
  • <=> - cosine distance
  • <+> - L1 distance
  • <~> - Hamming distance (binary vectors)
  • <%> - Jaccard distance (binary vectors)