Hacker News with Generative AI: Indexing

Comparing our Rust-based indexing and querying pipeline to Langchain (bosun.ai)
We frequently get asked why we’re building text (code) processing software in Rust and not in Python since our performance would be bottlenecked by the LLM inference anyway. In this article I’ll do some exploration on the performance of our Rust based indexing and querying pipeline, and how it compares to Python’s Langchain. In this specific scenario our tool is significantly faster, which we didn’t really expect, so I dove in and found out why.
B-Trees and Database Indexes (planetscale.com)
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
Show HN: Index and search *all* your documents (github.com/spapas)
I made a tool to index websites on Google in less than 48 hours (indexblaze.com)
Postgres Indexing: When Does Brin Win? (crunchydata.com)
A look at search engines with their own indexes (2021) (seirdy.one)
Regular Expression Matching with a Trigram Index (2012) (swtch.com)
Bloom Filter Indexes in PostgreSQL (postgresql.org)