bump pgvector to v0.7.0 and deprecating pg_sparse - Githubissues

Vonng / pigsty

Free RDS for PostgreSQL —— Pigsty

https://pigsty.io

GNU Affero General Public License v3.0

3.38k stars 258 forks source link

bump pgvector to v0.7.0 and deprecating pg_sparse #401

Closed Vonng closed 4 months ago

Vonng commented 5 months ago

https://twitter.com/jkatz05/status/1785003557948698873

https://github.com/pgvector/pgvector/blob/master/CHANGELOG.md#070-2024-04-29

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

And seems that pg_similarity can be deprecating too.

Vonng commented 5 months ago

It's now available on PGDG: https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-9-x86_64/

You could use the latest v0.7.0 with online installation. or adding them to exisintg repo with: https://pigsty.io/docs/pgsql/admin/#adding-packages

Vonng commented 4 months ago

resolved in v2.7