Mean

    Supercharging PostgreSQL with pgvector

    Karthikeya Panangipalliยท6 months ago
    postgrespgvectoraisearch

    pgvector โ†’ AI-powered Search ๐Ÿ”Ž

    pgvector adds a vector column type to Postgres so you can store and index embeddings:

    ALTER TABLE articles ADD COLUMN embedding vector(768);
    CREATE INDEX ON articles USING ivfflat (embedding);
    

    Semantic nearest-neighbour queries are now one SQL call away โ€” perfect for chatbots, recommendations and similarity search.

    Comments

    Please sign in to leave a comment.