Scaling and benchmarking a critical message bus using a new indexing strategy(blog.janestreet.com)
45 points by eatonphil | 3 comments
Jane Street blog post on scaling and benchmarking a critical internal message bus using a new indexing strategy.
#indexing on Hacker News
7 stories tagged indexing, newest first.
Unconventional PostgreSQL Optimizations(hakibenita.com)
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
SQLite JSON at full index speed using generated columns(dbpro.app)
334 points by upmostly | 102 comments
A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.
Google de-indexed Bear Blog and I don't know why(journal.james-zhan.com)
381 points by nafnlj | 163 comments
A personal blog post by James Zhan describing how Google de-indexed his entire Bear Blog a month after he started it, with no apparent reason.
PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth)(blog.vectorchord.ai)
377 points by VoVAllen | 80 comments
A VectorChord blog post arguing that PostgreSQL full-text search is fast when configured correctly, debunking claims that it is slow.
![Screenshot of cs-people.bu.edu: Data Structures for Data-Intensive Applications [pdf] (2023)](https://hn.urlbox.com/shots/renders/2024/2/10/a46b3788-3b16-4190-93af-2be4f407f4d9.jpg)
Data Structures for Data-Intensive Applications [pdf] (2023)(cs-people.bu.edu)
467 points by mfiguiere | 24 comments
A 2023 PDF monograph by Manos Athanassoulis et al. (Foundations and Trends) surveying data structures for data-intensive applications.
Absurd Success(marginalia.nu)
557 points by asicsp | 153 comments
A Marginalia blog post describing a week of coding that halved the search engine's RAM use, enabled online upgrades, and lifted index size limits.