TIN is a new full-text search extension for Postgres that supports boolean expressions, fuzzy matching, BM25 scoring, and concurrent updates while maintaining transaction visibility. The announcement includes benchmarks showing TIN's performance across various query types and large text corpora, addressing limitations in existing Postgres text-search indexes.
Neon announces TIN, a new full-text search extension for Postgres that supports boolean expressions, fuzzy matching, BM25 scoring, and concurrent updates. TIN outperforms existing text-search indexes by handling complex queries, joins, and transactions while maintaining high performance across large datasets like Wikipedia and Stack Exchange.