notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details
pgvector PostgreSQL extension for vector similarity search
0.8.0 databases on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 0.8.0Version of this port present on the latest quarterly branch.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-02-06 20:36:04
Last Update: 2025-01-01 12:00:13
Commit Hash: bca2014
People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py311-PyOpenGL, p5-Sane
License: PostgreSQL
WWW:
https://github.com/pgvector/pgvector/
Description:
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
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (46 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql16-pgvector-0.8.0/catalog.mk
  2. /usr/local/share/licenses/postgresql16-pgvector-0.8.0/LICENSE
  3. /usr/local/share/licenses/postgresql16-pgvector-0.8.0/PostgreSQL
  4. include/postgresql/server/extension/vector/halfvec.h
  5. include/postgresql/server/extension/vector/sparsevec.h
  6. include/postgresql/server/extension/vector/vector.h
  7. lib/postgresql/vector.so
  8. share/postgresql/extension/vector--0.1.0--0.1.1.sql
  9. share/postgresql/extension/vector--0.1.1--0.1.3.sql
  10. share/postgresql/extension/vector--0.1.3--0.1.4.sql
  11. share/postgresql/extension/vector--0.1.4--0.1.5.sql
  12. share/postgresql/extension/vector--0.1.5--0.1.6.sql
  13. share/postgresql/extension/vector--0.1.6--0.1.7.sql
  14. share/postgresql/extension/vector--0.1.7--0.1.8.sql
  15. share/postgresql/extension/vector--0.1.8--0.2.0.sql
  16. share/postgresql/extension/vector--0.2.0--0.2.1.sql
  17. share/postgresql/extension/vector--0.2.1--0.2.2.sql
  18. share/postgresql/extension/vector--0.2.2--0.2.3.sql
  19. share/postgresql/extension/vector--0.2.3--0.2.4.sql
  20. share/postgresql/extension/vector--0.2.4--0.2.5.sql
  21. share/postgresql/extension/vector--0.2.5--0.2.6.sql
  22. share/postgresql/extension/vector--0.2.6--0.2.7.sql
  23. share/postgresql/extension/vector--0.2.7--0.3.0.sql
  24. share/postgresql/extension/vector--0.3.0--0.3.1.sql
  25. share/postgresql/extension/vector--0.3.1--0.3.2.sql
  26. share/postgresql/extension/vector--0.3.2--0.4.0.sql
  27. share/postgresql/extension/vector--0.4.0--0.4.1.sql
  28. share/postgresql/extension/vector--0.4.1--0.4.2.sql
  29. share/postgresql/extension/vector--0.4.2--0.4.3.sql
  30. share/postgresql/extension/vector--0.4.3--0.4.4.sql
  31. share/postgresql/extension/vector--0.4.4--0.5.0.sql
  32. share/postgresql/extension/vector--0.5.0--0.5.1.sql
  33. share/postgresql/extension/vector--0.5.1--0.6.0.sql
  34. share/postgresql/extension/vector--0.6.0--0.6.1.sql
  35. share/postgresql/extension/vector--0.6.1--0.6.2.sql
  36. share/postgresql/extension/vector--0.6.2--0.7.0.sql
  37. share/postgresql/extension/vector--0.7.0--0.7.1.sql
  38. share/postgresql/extension/vector--0.7.1--0.7.2.sql
  39. share/postgresql/extension/vector--0.7.2--0.7.3.sql
  40. share/postgresql/extension/vector--0.7.3--0.7.4.sql
  41. share/postgresql/extension/vector--0.7.4--0.8.0.sql
  42. share/postgresql/extension/vector--0.8.0.sql
  43. share/postgresql/extension/vector.control
  44. @owner
  45. @group
  46. @mode
Collapse this list.
Dependency lines:
  • postgresql16-pgvector>0:databases/pgvector
To install the port:
cd /usr/ports/databases/pgvector/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgvector
  • pkg install postgresql16-pgvector
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql16-pgvector
Flavors: there is no flavor information for this port.
NOT_FOR_ARCHS: i386
distinfo:
TIMESTAMP = 1730668678 SHA256 (pgvector-pgvector-v0.8.0_GH0.tar.gz) = 867a2c328d4928a5a9d6f052cd3bc78c7d60228a9b914ad32aa3db88e9de27b0 SIZE (pgvector-pgvector-v0.8.0_GH0.tar.gz) = 122290

Packages (timestamps in pop-ups are UTC):
postgresql15-pgvector
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--------
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a--0.6.0
 

postgresql16-pgvector
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest0.8.00.8.0-0.8.0----
FreeBSD:13:quarterly0.8.00.8.0-0.8.0----
FreeBSD:14:latest0.8.00.8.0-0.8.0----
FreeBSD:14:quarterly0.8.00.8.0-0.8.0----
FreeBSD:15:latest0.8.00.8.0n/a0.8.0n/a---
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql16-server
Runtime dependencies:
  1. postgres : databases/postgresql16-server
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_pgvector
USES:
gmake pgsql
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/pgvector/pgvector/tar.gz/v0.8.0?dummy=/
Collapse this list.
Port Moves

Number of commits found: 10

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.8.0
01 Jan 2025 12:00:13
commit hash: bca20146b184606d573c34968c4abebeedbf3694commit hash: bca20146b184606d573c34968c4abebeedbf3694commit hash: bca20146b184606d573c34968c4abebeedbf3694commit hash: bca20146b184606d573c34968c4abebeedbf3694 files touched by this commit
Rene Ladan (rene) search for other commits by this committer
all: unregister expired postgresql12 and update affected USES
0.8.0
05 Nov 2024 14:19:41
commit hash: 3bda029d76b9bad41e6ab2115470698bcdc62786commit hash: 3bda029d76b9bad41e6ab2115470698bcdc62786commit hash: 3bda029d76b9bad41e6ab2115470698bcdc62786commit hash: 3bda029d76b9bad41e6ab2115470698bcdc62786 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.4
15 Sep 2024 07:45:01
commit hash: 723f5302fb06fc642d672ca5cf51c0079b38c914commit hash: 723f5302fb06fc642d672ca5cf51c0079b38c914commit hash: 723f5302fb06fc642d672ca5cf51c0079b38c914commit hash: 723f5302fb06fc642d672ca5cf51c0079b38c914 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.3
26 Jul 2024 20:38:10
commit hash: 0d6d385a0223ac61bb584321d55b58339be37ac4commit hash: 0d6d385a0223ac61bb584321d55b58339be37ac4commit hash: 0d6d385a0223ac61bb584321d55b58339be37ac4commit hash: 0d6d385a0223ac61bb584321d55b58339be37ac4 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.2
13 Jun 2024 12:39:47
commit hash: 489a66d3687e3984471847fdf3f5e1e90eb8d212commit hash: 489a66d3687e3984471847fdf3f5e1e90eb8d212commit hash: 489a66d3687e3984471847fdf3f5e1e90eb8d212commit hash: 489a66d3687e3984471847fdf3f5e1e90eb8d212 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.1
13 Jun 2024 11:50:48
commit hash: 704997f3dd641c6aa386271dd4f7f869f0bd6bbdcommit hash: 704997f3dd641c6aa386271dd4f7f869f0bd6bbdcommit hash: 704997f3dd641c6aa386271dd4f7f869f0bd6bbdcommit hash: 704997f3dd641c6aa386271dd4f7f869f0bd6bbd files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.1
04 Jun 2024 20:12:31
commit hash: 27f4f0e155a71aff10ce86c13114effc56d28318commit hash: 27f4f0e155a71aff10ce86c13114effc56d28318commit hash: 27f4f0e155a71aff10ce86c13114effc56d28318commit hash: 27f4f0e155a71aff10ce86c13114effc56d28318 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.7.0
03 May 2024 21:37:19
commit hash: 2adc60ebcca7264c025b42e75f4d0d5cb7872cb3commit hash: 2adc60ebcca7264c025b42e75f4d0d5cb7872cb3commit hash: 2adc60ebcca7264c025b42e75f4d0d5cb7872cb3commit hash: 2adc60ebcca7264c025b42e75f4d0d5cb7872cb3 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.6.2
31 Mar 2024 22:20:34
commit hash: 3001deeaded49bea4242807dc7ec56353dc98052commit hash: 3001deeaded49bea4242807dc7ec56353dc98052commit hash: 3001deeaded49bea4242807dc7ec56353dc98052commit hash: 3001deeaded49bea4242807dc7ec56353dc98052 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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
0.6.0
06 Feb 2024 20:31:13
commit hash: 65494cab7b3d95c81e99957fc49e6f7e8e9a9b4dcommit hash: 65494cab7b3d95c81e99957fc49e6f7e8e9a9b4dcommit hash: 65494cab7b3d95c81e99957fc49e6f7e8e9a9b4dcommit hash: 65494cab7b3d95c81e99957fc49e6f7e8e9a9b4d files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
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>

Number of commits found: 10