Introducing TIN: full-text search for Postgres
Summary
PlanetScale introduces TIN, a fast full-text search extension for Postgres that uses Postgres ctids as document identifiers. The article provides benchmarks showing TIN outperforming ParadeDB, pg_textsearch, and Postgres GIN across several query types and discusses architectural choices that enable high throughput and MVCC correctness. It also explains segmenting and merging, and how TIN integrates with Postgres for efficient searches.