Tin: full-text search for Postgres

Postgres developers have released TIN, a new full-text search extension for PostgreSQL. This powerful tool aims to meet the demands of developers seeking a comprehensive search solution for their applications. TIN stands for "Text INdex" and is designed to support various search requirements, including handling joins, complex WHERE clauses, continuous updates, replication, backups, and maintaining correct transaction visibility.

The developers behind TIN were dissatisfied with existing text-search indexes for PostgreSQL, as none of them could handle all of the necessary features. TIN addresses these limitations and offers exceptional performance. Benchmarks show that TIN can handle 25 times more queries per second than ParadeDB, with p99 latencies 26 times lower.

When compared to ParadeDB and PostgreSQL's built-in GIN index, TIN performs 10 times and 541 times better, respectively, while maintaining significantly lower p99 latencies. TIN also outperforms pg_textsearch in handling disjunction queries and concurrent updates, completing 270,279 updates per minute while ParadeDB handles 185,584, and pg_textsearch can only manage 735.