Stack Overflow
Stack Overflow

Questions tagged [pgvector]

14 questions
4
votes
1 answer

Is it possible to add pgvector extension on top of postgres:15.3-alpine images

I'm trying to dockerize pg-vector and I found this Dockerfile from the official repository. https://github.com/pgvector/pgvector/blob/master/Dockerfile#L2C1-L3C1 The Dockerfile currently uses postgres base image right now, I'm wondering if I can add…
daniel1kp
  • 41
  • 3
4
votes
1 answer

What JPA + Hibernate data type should I use to support the vector extension in a PostgreSQL database?

What JPA + Hibernate data type should I use to support the vector extension in a PostgreSQL database, so that it allows me to create embeddings using a JPA Entity? CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3)); pgvector
user352290
  • 473
  • 1
  • 5
  • 16
2
votes
0 answers

Unable to install pgvector extension for PostgreSQL [Windows]

I am trying to use PostgreSQL as a vector database. And for the same I installed PostgreSQL to my windows system using the instructions provided here. To install pgvector, I followed the instructions given in this page. I am trying to complete this…
Sai Kirtana G
  • 21
  • 2
1
vote
1 answer

How to use VectorStoreRetrieverMemory in langchain with PGVector?

I want to use VectorStoreRetrieverMemory in langchain with PGVector in python. I didn't get any documents related to it. can someone help me with it.
Andrea Bency
  • 43
  • 3
1
vote
2 answers

How should I add custom validation to the Django admin for a non-standard model field?

I have a non-standard Django model field (PostgreSQL pgvector) which is resulting in a validation error when the admin application attempts to naively validate it: The truth value of an array with more than one element is ambiguous. Use a.any() or…
pdoherty926
  • 9,895
  • 4
  • 37
  • 68
1
vote
1 answer

Reduce vector dimension 4096 -> less than 2000 for Postgres

I am using Postgresql with pgvector for searching similarity between images. The vector should have up to 2000 dimensions, so that Postgres/pgvector can index it. I am creating a vector of the image with Python and VGG16/VGG19. As a result, I get a…
Pio92
  • 11
  • 1
1
vote
1 answer

Installing pgvector extension on mac for postgres

I'm trying to install postgres vector extension on my mac but am getting 1 error generated. make: *** [src/ivfbuild.o] Error 1 clang -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels…
Sergei Egorov
  • 11
  • 2
1
vote
1 answer

How do I integrate a custom input argument into a Graphene DjangoFilterConnectionField queryset?

I'm wondering what the cleanest way to integrate a Graphene DjangoFilterConnectionField custom input argument into the default queryset is? I'm iterating on the following Graphene Query class whose custom input attribute attempts to integrate the…
pdoherty926
  • 9,895
  • 4
  • 37
  • 68
0
votes
0 answers

Django slice then filter queryset

I'm trying to use pgvector to find similar products by name, I've built the embedding on the name, now, when I try to use the method that is stated on the docs for pgvector in order to get the products with a certain distance using ALIAS the query…
El hosayn Ait Ali
  • 43
  • 1
  • 6
0
votes
0 answers

Postgresql 15, pgvector and Ruby on Rails 7 - vector.control cannot be found

Our CI/CD uses GitHub actions for, among other things, running our test suite. When the database is set up in the action workflow, it fails when it attempts to run "CREATE EXTENSION vector;" (in the Rails migration, it's "enable_extension…
Ron
  • 1
0
votes
0 answers

Get data from multiple collection of PGVector using langchain

I have multiple collection in PGVector DB COLLECTION_NAME1 = "mydata1" COLLECTION_NAME2 = "mydata2" Now I am using PGVector method to load data from it based on the collection embeddings = OpenAIEmbeddings() store1 = PGVector( …
utsav vc
  • 17
  • 3
0
votes
0 answers

error: broken symbolic link to ../../../Cellar/pgvector/0.4.4/share/postgresql@14/extension/vector.control

I'm trying to install pgvector, and I run into the following error after I run "make install" after the cloning, and running "make". I run the following: cd /tmp git clone --branch v0.4.4 https://github.com/pgvector/pgvector.git cd…
akash
  • 1
  • 1
0
votes
2 answers

pgvector extension on Google Cloud SQL Postgres

Google Cloud SQL recently announced support for Postgres extension pgvector. But it's not available in the list of extensions supported SELECT * FROM pg_available_extensions;. I'm on version 9.6. What do I need to do to see the extension?
Abs
  • 2,234
  • 1
  • 19
  • 27
0
votes
0 answers

pgvector , VGG , image vector - dimensions

I'm using python to get the image vector. By VGG I receives a 4096 elements vector (float). [0.00e+00 0.00e+00 0.0e+00 0.00e+00 ... 0.00e+00 5.27714975e-02 0.00e+00] I want to save this vector in the database (Postgres) and such for a similar…
Pio92
  • 11
  • 1