You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE tweet_embeddings AS
SELECT text, pgml.embed('distilbert-base-uncased', text) AS embedding
FROM pgml.tweet_eval;
Creating index fails:
CREATE INDEX ON tweet_embeddings USING ivfflat (embedding vector_cosine_ops);
--
ERROR: access method "ivfflat" does not exist
1 statement failed.
Using ::vector fails:
WITH query AS (
SELECT pgml.embed('distilbert-base-uncased', 'Star Wars christmas special is on Disney')::vector AS embedding
)
SELECT * FROM items, query ORDER BY items.embedding <-> query.embedding LIMIT 5;
--
ERROR: type "vector" does not exist
Position: 113
SELECT pgml.embed('distilbert-base-uncased', 'Star Wars christmas special is on Disney')::vector AS embedding
^
1 statement failed.
I am trying to use the docker image. My environment: Ubuntu 22.04 with GPU, docker
I got these errors:
ERROR: access method "ivfflat" does not exist (when creating index)
ERROR: type "vector" does not exist (when using
::vector
in select statemen)What I did:
Connected with SQL client to port 5499
I want to reproduce steps described in "Vector database", see https://github.com/postgresml/postgresml/?tab=readme-ov-file#vector-database
SELECT pgml.load_dataset('tweet_eval', 'sentiment');
Created table with embeddings:
::vector
fails:Documentation (see https://postgresml.org/docs/product/vector-database) say literally this:
Well... I am using your latest Docker image, and...
The text was updated successfully, but these errors were encountered: