Introducing TIN: full-text search for Postgres

This post introduces TIN, a new full-text search extension for PostgreSQL. It details the design goals, including support for boolean expressions, phrase queries, fuzzy matching, and ranked results. Extensive benchmarks are presented comparing TIN against ParadeDB, pg_textsearch, and Postgres GIN across various workloads (conjunction, disjunction, phrase, count queries) with and without concurrent writes. The benchmarks highlight TIN's superior QPS, lower p99 latencies, and reduced MB/query compared to alternatives, demonstrating its performance advantages in build time, index size, and query execution.