Hacker News with Generative AI: Full-Text Search

PostgreSQL Full-Text Search: Fast When Done Right (Debunking the Slow Myth) (vectorchord.ai)
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.
PostgreSQL, Full-Text Search, Databases, Performance, Optimization
427 points by VoVAllen 17 days ago | 85 comments
BM25 in PostgreSQL (vectorchord.ai)
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 scoring and ranking right into PostgreSQL, making your searches smarter and faster.
PostgreSQL, Databases, Search, Full-Text Search, Open Source
139 points by gaocegege 54 days ago | 31 comments