Open-source vector similarity search for Postgres
Store your vectors with the rest of your data. Supports:
* exact and approximate nearest neighbor search
* L2 distance, inner product, and cosine distance
* any language with a Postgres client
Plus ACID compliance, point-in-time recovery, JOINs, and all of the other great
features of Postgres
databases/pgvector: Upgrade from 0.8.2 to 0.8.7
Changelog for each version:
0.8.7 (2026-10-01)
Fixed buffer overflow with IVFFlat index build
Fixed error with avg aggregate when no matching rows
0.8.6 (2026-07-29)
Fixed buffer overflow with IVFFlat index build on 32-bit systems
Fixed array to sparsevec cast not limiting non-zero elements
Fixed memory usage for IVFFlat index scans with nested loop joins
(Only the first 15 lines of the commit message are shown above )
databases/pgvector: Update from 0.8.1 to 0.8.2
Changelog:
* Fixed buffer overflow with parallel HNSW index build - more info
* Improved install target on Windows
* Fixed Index Searches in EXPLAIN output for Postgres 18
Taken from:
https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md
Sponsored by: OTTRIA
databases/pgvector: Update from 0.7.4 to 0.8.0
Changelog:
* Added support for iterative index scans
* Added casts for arrays to sparsevec
* Improved cost estimation for better index selection when filtering
* Improved performance of HNSW index scans
* Improved performance of HNSW inserts and on-disk index builds
* Dropped support for Postgres 12
Taken from:
https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md
databases/pgvector: Update from 0.7.3 to 0.7.4
Changelog:
* Fixed locking for parallel HNSW index builds
* Fixed compilation error with GCC 14 on i386 when SSE2 is not enabled
Taken from:
https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md
Sponsored by: P. Variablis
databases/pgvector: Update from 0.7.2 to 0.7.3
Changelog:
* Fixed failed to add index item error with sparsevec
* Fixed compilation error with FreeBSD ARM
* Fixed compilation warning with MSVC and Postgres 16
Taken from:
https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md
MFH: 2024Q3
databases/pgvector: Upgrade from 0.7.1 to 0.7.2
Changelog:
* Fixed initialization fork for indexes on unlogged tables
MFH: 2024Q2
Sponsored by: P. Variablis
databases/pgvector: Exclude from i386
It does not compile on i386. Error message is:
In file included from src/halfutils.c:3:
src/halfutils.h:27:9: error: controlling expression type '_Float16' not
compatible with any generic association type
return isnan(num);
^~~~~~~~~~
/usr/include/math.h:103:2: note: expanded from macro 'isnan'
__fp_type_select(x, __inline_isnanf, __inline_isnan, __inline_isnanl)
^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/usr/include/math.h:80:62: note: expanded from macro '__fp_type_select'
#define __fp_type_select(x, f, d, ld) __extension__ _Generic((x), \
^~~
1 error generated.
gmake: *** [<builtin>: src/halfutils.o] Error 1
*** Error code 1
Sponsored by: P. Variablis
databases/pgvector: Update from 0.7.0 to 0.7.1
Changelog:
* Improved performance of on-disk HNSW index builds
* Fixed undefined symbol error with GCC 8
* Fixed compilation error with universal binaries on Mac
* Fixed compilation warning with Clang < 14
MFH: 2024Q2
Sponsored by: P. Variablis
databases/pgvector: Update from 0.6.2 to 0.7.0
Changelog:
Added halfvec type
Added sparsevec type
Added support for indexing bit type
Added support for indexing L1 distance with HNSW
Added binary_quantize function
Added hamming_distance function
Added jaccard_distance function
Added l2_normalize function
Added subvector function
Added concatenate operator for vectors
Added CPU dispatching for distance functions on Linux x86-64
Updated comparison operators to support vectors with different dimensions
Sponsored by: P. Variablis GmbH
databases/pgvector: Upgrade from 0.6.0 to 0.6.2
Changelog:
0.6.2 (2024-03-18)
Reduced lock contention with parallel HNSW index builds
0.6.1 (2024-03-04)
Fixed error with ANALYZE and vectors with different dimensions
Fixed segmentation fault with shared_preload_libraries
Fixed vector subtraction being marked as commutative
PR: 277752
Reported by: wen
databases/pg_vector: Rename to match upstream and fix license
Also split DISTVERSION into PORTVERSION and DISTVERSIONPREFIX
PR: 276846
Reported by: Andrew Kane <andrew@ankane.org>
