Trace Id is missing
Skip to main content
Azure
NOW AVAILABLE

General Availability: Pgvector 0.7 support in Azure Database for PostgreSQL – Flexible Server

Published date: July 18, 2024

Support for the latest open-source version of pgvector, version 0.7, is now generally available for Azure Database for PostgreSQL - Flexible Server. This updated version of pgvector provides multiple performance improvements including,

  • Support for binary vectors using the bit type with indexing up to 64,000 dimensions
  • Support for quantizing vectors using expression indexes
  • Support for HNSW indexing for L1 distance operations

Pgvector 0.7 also adds two new vector types,

  • halfvec: 2-byte floats with support to index up to 4,000 dimensions
  • sparsevec: a vector where most of its elements are zero with support for up to 1,00 nonzero dimensions

Lastly, gvector 0.7 introduces new distance functions including hamming_distance and jaccard_distance for bit vectors.

Pgvector is a popular extension for efficient vector similarity searches within PostgreSQL. This update creates new possibilities for developers working on machine learning and search applications, by allowing them to leverage PostgreSQL for vector operations. With pgvector 0.7.0, users can expect enhanced performance and new features that make working with vector data more efficient and effective.

Learn more.