Home / Companies / Supabase / Blog / Post Details
Content Deep Dive

vec2pg: Migrate to pgvector from Pinecone and Qdrant

Blog post from Supabase

Post Details
Company
Date Published
Author
Oliver Rice
Word Count
670
Company Posts That Month
18
Language
English
Hacker News Points
-
Post removed?
No
Summary

vec2pg is a CLI utility that facilitates the migration of data from various vector databases into Postgres with associated ids and metadata. The tool supports migrating from Pinecone and Qdrant, and it allows users to manipulate the data using SQL to transform it into their preferred schema. When migrating, users should increase their Supabase project's disk size to accommodate the vectors. The performance of `vec2pg` is dependent on several factors, including network speed, vector dimensionality, and metadata size. Pinecone and Qdrant collections can be migrated at rates of 700-1100 records per second and 900-2500 records per second, respectively. Postgres/pgvector offers several benefits, including performance, scalability, security, backups, row-level security, and compatibility with a wide ecosystem of tools. The tool is designed to make it easy for users to efficiently copy their data from various vector databases into Postgres, allowing them to manipulate the data using SQL and transform it into their preferred schema.

Trends Found in this Post
Trend Post Mentions Total Month Mentions Posts Companies MoM
Vector Search 4 2,325 291 104 +36%
Serverless 1 527 139 76 +10%
Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.