Skip to content

Jinjing Zhou

Core Engineer at TensorChord · Lead author of VectorChord, vchord_bm25, and pg_tokenizer (@VoVAllen)

Core database and systems engineer at TensorChord, lead architect of vchord, vchord_bm25, pg_tokenizer, and pg_bestmatch. Follow on GitHub (@VoVAllen).

  • VectorChord 1.0: Developer-First Vector Search on Postgres, 100x Faster Indexing than pgvector

    By Jinjing Zhou In Release Notes 2598 words 13 min

    Jinjing Zhoureleasevectorchord

    VectorChord 1.0: Developer-First Vector Search on Postgres, 100x Faster Indexing than pgvector

    Two years ago, when we published the very first pgvecto.rs blog post, we made a bet: Postgres is the best place to do vector search. Since then we’ve been iterating on that bet — from VBASE with filtered vector search, to longer vector support, to …

    Two years ago, when we published the very first pgvecto.rs blog post, we made a bet: Postgres is the best place to do vector search. Since then we’ve been iterating on that bet — from VBASE with filtered vector search, to longer vector support, to …

  • VectorChord 0.4: Faster PostgreSQL Vector Search with Advanced I/O and Prefiltering

    By Jinjing Zhou In Release Notes 791 words 4 min

    Jinjing Zhoureleasepgvectorvectorchord

    VectorChord 0.4: Faster PostgreSQL Vector Search with Advanced I/O and Prefiltering

    We’re excited to announce the release of VectorChord 0.4, a significant update that enhances high-performance vector search within PostgreSQL. We believe this release pushes the boundaries of what’s possible for vector search in PostgreSQL, …

    We’re excited to announce the release of VectorChord 0.4, a significant update that enhances high-performance vector search within PostgreSQL. We believe this release pushes the boundaries of what’s possible for vector search in PostgreSQL, …

  • VectorChord 0.3: Bringing Efficient Multi-Vector Contextual Late Interaction in PostgreSQL

    By Keming, Jinjing Zhou In Release Notes 1606 words 8 min

    KemingJinjing Zhoureleasemultivectorvectorchord

    VectorChord 0.3: Bringing Efficient Multi-Vector Contextual Late Interaction in PostgreSQL

    We’re thrilled to announce the release of VectorChord 0.3, a major milestone that significantly boosts the performance and applicability of advanced vector search techniques directly within your Postgres database! Building on our 0.2 release, which …

    We’re thrilled to announce the release of VectorChord 0.3, a major milestone that significantly boosts the performance and applicability of advanced vector search techniques directly within your Postgres database! Building on our 0.2 release, which …

  • 3 Billion Vectors in PostgreSQL to Protect the Earth

    By Jinjing Zhou In Engineering 1829 words 9 min

    Jinjing Zhoupostgresql

    3 Billion Vectors in PostgreSQL to Protect the Earth

    Monitoring the health of our planet is one of the most critical challenges of our time. Our planet faces immense environmental pressures, and understanding these changes requires sifting through an unimaginable amount of satellite data – petabytes of …

    Monitoring the health of our planet is one of the most critical challenges of our time. Our planet faces immense environmental pressures, and understanding these changes requires sifting through an unimaginable amount of satellite data – petabytes of …

  • VectorChord-BM25: Introducing pg_tokenizer—A Standalone, Multilingual Tokenizer for Advanced Search

    By Jinjing Zhou In Engineering 1135 words 3 min

    Jinjing Zhouvector-databasevectorchord

    VectorChord-BM25: Introducing pg_tokenizer—A Standalone, Multilingual Tokenizer for Advanced Search

    We’re excited to announce the release of VectorChord-BM25 version 0.2, our PostgreSQL extension designed to bring advanced BM25-based full-text search ranking capabilities directly into your database! VectorChord-BM25 allows you to leverage the power …

    We’re excited to announce the release of VectorChord-BM25 version 0.2, our PostgreSQL extension designed to bring advanced BM25-based full-text search ranking capabilities directly into your database! VectorChord-BM25 allows you to leverage the power …

  • PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)

    By Jinjing Zhou, Junyu Chen In Engineering 1215 words 6 min

    Jinjing ZhouJunyu Chenbm25

    PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)

    You might have come across discussions or blog posts suggesting that PostgreSQL’s built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon’s …

    You might have come across discussions or blog posts suggesting that PostgreSQL’s built-in full-text search (FTS) struggles with performance compared to dedicated search engines or specialized extensions. A notable recent example comes from Neon’s …

  • VectorChord-BM25: Revolutionize PostgreSQL Search with BM25 Ranking — 3x Faster Than ElasticSearch

    By Jinjing Zhou In Engineering 2588 words 13 min

    Jinjing Zhoupostgresqlvectorchord

    VectorChord-BM25: Revolutionize PostgreSQL Search with BM25 Ranking — 3x Faster Than ElasticSearch

    We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 …

    We’re excited to share something special with you: VectorChord-BM25, a new extension designed to make PostgreSQL’s full-text search even better. Whether you’re building a small app or managing a large-scale system, this tool brings advanced BM25 …

  • VectorChord 0.2: 60K-Dimensional Vectors, 50% Faster Indexing with ARM

    By Jinjing Zhou In Release Notes 847 words 4 min

    Jinjing Zhoureleasepostgresqlvectorchord

    VectorChord 0.2: 60K-Dimensional Vectors, 50% Faster Indexing with ARM

    Today, we’re thrilled to share VectorChord 0.2—a release shaped by community feedback and designed to tackle the evolving challenges of vector search in PostgreSQL. %[https://github.com/tensorchord/VectorChord/] Optimized Storage Layout: Supporting …

    Today, we’re thrilled to share VectorChord 0.2—a release shaped by community feedback and designed to tackle the evolving challenges of vector search in PostgreSQL. %[https://github.com/tensorchord/VectorChord/] Optimized Storage Layout: Supporting …

  • Why HNSW is Not the Answer

    By Jinjing Zhou In Engineering 1132 words 6 min

    Jinjing Zhoupostgresql

    Why HNSW is Not the Answer

    HNSW (Hierarchical Navigable Small World) has become the go-to algorithm for many vector databases. Its multi-layered graph structure and ability to efficiently navigate vector embeddings make it particularly appealing. However, despite its apparent …

    HNSW (Hierarchical Navigable Small World) has become the go-to algorithm for many vector databases. Its multi-layered graph structure and ability to efficiently navigate vector embeddings make it particularly appealing. However, despite its apparent …

  • VectorChord: Store 400k Vectors for $1 in PostgreSQL

    By Ce Gao, Jinjing Zhou, Junyu Chen In Engineering 1314 words 7 min

    Ce GaoJinjing ZhouJunyu Chenvectorchord

    VectorChord: Store 400k Vectors for $1 in PostgreSQL

    We’re pleased to announce our new vector search extension for PostgreSQL, providing a highly cost-effective way to manage large vectors. Using VectorChord, you can achieve a QPS of 131 with 0.95 precision on 100 million 768-dimensional vectors for …

    We’re pleased to announce our new vector search extension for PostgreSQL, providing a highly cost-effective way to manage large vectors. Using VectorChord, you can achieve a QPS of 131 with 0.95 precision on 100 million 768-dimensional vectors for …

  • pg_bestmatch.rs: Elevate Your PostgreSQL Text Queries with BM25

    By Jinjing Zhou In Engineering 591 words 3 min

    Jinjing Zhourag

    pg_bestmatch.rs: Elevate Your PostgreSQL Text Queries with BM25

    Tip Update: Check our latest extension VectorChord-BM25 for end2end BM25 ranking in PostgreSQL. Read more at https://vchord.pgsty.com/blog/post/vectorchord-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch/ …

    Tip Update: Check our latest extension VectorChord-BM25 for end2end BM25 ranking in PostgreSQL. Read more at https://vchord.pgsty.com/blog/post/vectorchord-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch/ …