Skip to content

Engineering & Deep Dives

Engineering & Deep Dives
Why HNSW is Not the Answer postgresql
Benefits and Steps of External Centroids Building in VectorChord vectorsearchvectorchord
VectorChord: Store 400k Vectors for $1 in PostgreSQL vectorchord
Introducing PGVecto.rs Cloud - Scalable Vector Search in PostgreSQL, Now in the Cloud vector-database
Introducing Terraform Support for PGVecto.rs Cloud postgresql
Unleash the power of sparse vector sparsevectors
pg_bestmatch.rs: Elevate Your PostgreSQL Text Queries with BM25 rag
My binary vector search is better than your FP32 vectors postgresql
pgvector vs. pgvecto.rs in 2024: A Comprehensive Comparison for Vector Search in PostgreSQL
Do we really need a specialized vector database? ai
Building the RAG pipeline with LlamaIndex and pgvecto.rs ai
Building LLM Applications in LangChain using pgvecto.rs ai

Why HNSW is Not the Answer

1132 words 6 min

HNSW (Hierarchical Navigable Small World) has become the go-to algorithm for many vector databases. Its multi-layered graph structure and ability to…

  • Why HNSW is Not the Answer

    In Engineering 1132 words 6 min

    postgresql

    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 …

  • Benefits and Steps of External Centroids Building in VectorChord

    In Engineering 701 words 4 min

    vectorsearchvectorchord

    Clustering is an important component in vector search, and the k-means algorithm remains one of the most widely used techniques. However, its simplicity comes with a significant drawback: resource-intensive computation can render it impractical for …

    Clustering is an important component in vector search, and the k-means algorithm remains one of the most widely used techniques. However, its simplicity comes with a significant drawback: resource-intensive computation can render it impractical for …

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

    In Engineering 1314 words 7 min

    vectorchord

    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 …

  • Introducing PGVecto.rs Cloud - Scalable Vector Search in PostgreSQL, Now in the Cloud

    In Engineering 379 words 2 min

    vector-database

    In an exciting development, we are thrilled to announce the launch of PGVecto.rs Cloud - bringing the power of scalable vector search to your PostgreSQL databases, now available as a fully managed cloud service. PGVecto.rs is a pioneering Postgres …

    In an exciting development, we are thrilled to announce the launch of PGVecto.rs Cloud - bringing the power of scalable vector search to your PostgreSQL databases, now available as a fully managed cloud service. PGVecto.rs is a pioneering Postgres …

  • Introducing Terraform Support for PGVecto.rs Cloud

    In Engineering 1886 words 9 min

    postgresql

    We are thrilled to announce the release of our Terraform provider for PGVecto.rs Cloud. This new provider is designed to simplify the process of managing resources on our cloud service, providing users with an intuitive and streamlined experience for …

    We are thrilled to announce the release of our Terraform provider for PGVecto.rs Cloud. This new provider is designed to simplify the process of managing resources on our cloud service, providing users with an intuitive and streamlined experience for …

  • Unleash the power of sparse vector

    In Engineering 1433 words 7 min

    sparsevectors

    In the past, hybrid search combined two search methods: traditional keyword-based search and vector-based similarity search. However, sparse vector can act as a substitute for keyword search, unlocking the full potential of the data pipeline with …

    In the past, hybrid search combined two search methods: traditional keyword-based search and vector-based similarity search. However, sparse vector can act as a substitute for keyword search, unlocking the full potential of the data pipeline with …

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

    In Engineering 591 words 3 min

    rag

    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/ …

  • My binary vector search is better than your FP32 vectors

    In Engineering 1227 words 6 min

    postgresql

    Within the field of vector search, an intriguing development has arisen: binary vector search. This approach shows promise in tackling the long-standing issue of memory consumption by achieving a remarkable 30x reduction. However, a critical aspect …

    Within the field of vector search, an intriguing development has arisen: binary vector search. This approach shows promise in tackling the long-standing issue of memory consumption by achieving a remarkable 30x reduction. However, a critical aspect …

  • pgvector vs. pgvecto.rs in 2024: A Comprehensive Comparison for Vector Search in PostgreSQL

    In Engineering 1462 words 7 min

    pgvector and pgvecto.rs are both vector search extensions designed to enhance the capabilities of PostgreSQL. These extensions revolutionize the way vector search is performed within the database, providing scalable, low-latency, and hybrid-enabled …

    pgvector and pgvecto.rs are both vector search extensions designed to enhance the capabilities of PostgreSQL. These extensions revolutionize the way vector search is performed within the database, providing scalable, low-latency, and hybrid-enabled …

  • Do we really need a specialized vector database?

    In Engineering 2624 words 13 min

    ai

    With the popularity of LLM (Large Language Model), vector databases have also become a hot topic. With just a few lines of simple Python code, a vector database can act as a cheap but highly effective “external brain” for your LLM. But do we really …

    With the popularity of LLM (Large Language Model), vector databases have also become a hot topic. With just a few lines of simple Python code, a vector database can act as a cheap but highly effective “external brain” for your LLM. But do we really …

  • Building the RAG pipeline with LlamaIndex and pgvecto.rs

    In Engineering 289 words 2 min

    ai

    LlamaIndex is a simple, flexible data framework for connecting custom data sources to large language models (LLMs). pgvecto.rs provides a LlamaIndex integration that allows you to retrieve the most similar vectors. In this blog post, we will show you …

    LlamaIndex is a simple, flexible data framework for connecting custom data sources to large language models (LLMs). pgvecto.rs provides a LlamaIndex integration that allows you to retrieve the most similar vectors. In this blog post, we will show you …

  • Building LLM Applications in LangChain using pgvecto.rs

    In Engineering 717 words 4 min

    ai

    LangChain is a framework for developing applications powered by language models. It enables applications that: Are context-aware: connect a language model to sources of context (prompt instructions, few shot examples, content to ground its response …

    LangChain is a framework for developing applications powered by language models. It enables applications that: Are context-aware: connect a language model to sources of context (prompt instructions, few shot examples, content to ground its response …