Skip to content

postgresql

13 pages
  • VectorChord 0.5: New RaBitQ-empowered DiskANN Index and Continuous Recall Measurement

    In Release Notes 1404 words 7 min

    releasepostgresqlvectorchord

    We’re thrilled to announce the release of VectorChord 0.5! This release marks a significant step forward in our mission to provide more flexible, powerful, and controllable vector search capabilities. In the 0.5 release, we’re introducing two major …

    We’re thrilled to announce the release of VectorChord 0.5! This release marks a significant step forward in our mission to provide more flexible, powerful, and controllable vector search capabilities. In the 0.5 release, we’re introducing two major …

  • Bringing Search‑Engine Ranking to PostgreSQL with VectorChord‑BM25

    In Engineering 880 words 5 min

    postgresqlvectorchord

    Modern applications rely on PostgreSQL for its fully ACID‑compliant, expressive SQL, and rich ecosystem of extensions. The database handles relational workloads exceptionally well, but many projects also need to search for large text …

    Modern applications rely on PostgreSQL for its fully ACID‑compliant, expressive SQL, and rich ecosystem of extensions. The database handles relational workloads exceptionally well, but many projects also need to search for large text …

  • VectorChord: Cost-Efficient Upload & Search of 400 Million Vectors on AWS

    In Engineering 1668 words 8 min

    postgresqlvectorchord

    In this article, we will describe one method for uploading, indexing, and searching a big dataset of vector data in a cost-efficient manner using the real-world LAION-400M dataset and the VectorChord extension in PostgreSQL. We’re attempting to show …

    In this article, we will describe one method for uploading, indexing, and searching a big dataset of vector data in a cost-efficient manner using the real-world LAION-400M dataset and the VectorChord extension in PostgreSQL. We’re attempting to show …

  • All-in-one VectorChord Suite: Building Production-Ready RAG Solutions Directly in PostgreSQL

    In Engineering 998 words 5 min

    postgresqlvectorchord

    Retrieval-Augmented Generation (RAG) is revolutionizing our interaction with vast datasets and language models. RAG systems offer more precise, contextually aware, and current answers by retrieving pertinent information before generating responses. …

    Retrieval-Augmented Generation (RAG) is revolutionizing our interaction with vast datasets and language models. RAG systems offer more precise, contextually aware, and current answers by retrieving pertinent information before generating responses. …

  • 3 Billion Vectors in PostgreSQL to Protect the Earth

    In Engineering 1829 words 9 min

    postgresql

    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 …

  • Hybrid search with Postgres Native BM25 and VectorChord

    In Engineering 1905 words 9 min

    postgresqlvectorchord

    In the era of RAG (Retrieval-Augmented Generation), efficiently retrieving relevant data from vast datasets is crucial for businesses and developers. Traditional keyword-based retrieval methods, such as those utilizing BM25 as a scoring mechanism, …

    In the era of RAG (Retrieval-Augmented Generation), efficiently retrieving relevant data from vast datasets is crucial for businesses and developers. Traditional keyword-based retrieval methods, such as those utilizing BM25 as a scoring mechanism, …

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

    In Engineering 2588 words 13 min

    postgresqlvectorchord

    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 …

  • Do we really need a specialized vector database? (2023)

    In Engineering 2667 words 13 min

    postgresql

    Notice: This article, originally published in 2023, discusses the relevance and necessity of specialized vector databases, particularly in relation to Postgres and its capabilities. For further insights and discussions on this topic, please refer to …

    Notice: This article, originally published in 2023, discusses the relevance and necessity of specialized vector databases, particularly in relation to Postgres and its capabilities. For further insights and discussions on this topic, please refer to …

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

    In Release Notes 847 words 4 min

    releasepostgresqlvectorchord

    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 …

  • ARM + VectorChord: Affordable, Fast Vector Search

    In Engineering 538 words 3 min

    postgresqlvectorchord

    ARM64 is quietly becoming a go-to for cost-effective cloud servers, especially on AWS. With ARM-based processors like the Graviton series (Graviton3 and Graviton4), you can save a good chunk of money without sacrificing performance. These ARM64 …

    ARM64 is quietly becoming a go-to for cost-effective cloud servers, especially on AWS. With ARM-based processors like the Graviton series (Graviton3 and Graviton4), you can save a good chunk of money without sacrificing performance. These ARM64 …

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

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

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