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

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it''''''''s already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

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