pgvector vs TiDB

Side-by-side comparison of two AI agent tools

Short answer

  • pgvector is growing faster: +435 GitHub stars in the last 30 days vs +60 for TiDB.
  • Pick pgvector for: open-source vector similarity search for Postgres. Pick TiDB for: open-source, cloud-native distributed SQL database with ACID, horizontal scaling, HTAP, and vector search.

From GitHub data refreshed daily.

Open-source vector similarity search for Postgres

T
TiDBopen-source

Open-source, cloud-native distributed SQL database with ACID, horizontal scaling, HTAP, and vector search

Metrics

pgvectorTiDB
Stars23.2k40.6k
Star velocity /mo434.842105263157960
Commits (90d)128382
Releases (6m)04
Overall score0.61924275093482480.62252105643632

Pros

  • +Native PostgreSQL integration preserves ACID compliance, transactions, and allows complex JOINs between vector and relational data
  • +Supports multiple vector types (single/half-precision, binary, sparse) and distance metrics (L2, cosine, inner product, Hamming, Jaccard)
  • +Wide ecosystem compatibility with any language that has a Postgres client and available through multiple installation methods

    Cons

    • -Requires PostgreSQL expertise and may have steeper learning curve compared to dedicated vector databases
    • -Installation complexity varies by platform, especially on Windows systems
    • -Performance may not match specialized vector databases for very large-scale vector workloads

      Use Cases

      • •RAG (Retrieval Augmented Generation) applications where embeddings need to be stored alongside document metadata and user data
      • •E-commerce recommendation systems that combine vector similarity with product catalog data and user preferences
      • •Semantic search applications where vector queries need to be combined with traditional filters and business logic

        FAQ

        Which is more popular, pgvector or TiDB?
        TiDB has more GitHub stars (40,621 vs 23,226).
        Which is more actively developed, pgvector or TiDB?
        TiDB had more commits in the last 90 days (382 vs 128).
        Should I use pgvector or TiDB?
        Compare their capabilities, limitations and "best for" notes above. Trying each on a small task is the fastest way to decide.