GoKawiilEric Ridge, Patrick Reynolds | September 16, 2026
One of the Postgres features our customers ask us for the most is full-text search. Today, we are excited to announce TIN: a fast, full-featured, reliable full-text search extension for Postgres. TIN stands for "Text INdex," and that is what it does.
TIN is available immediately as a GA release for all Postgres and Neki databases. Check it out:
CREATE INDEX an_index_name ON table_name USING tin(text_column_name); SELECT * FROM table_name WHERE text_column_name ==> 'some words' ;
We built TIN because we believe a good text index should support:
Boolean expressions, phrase queries, and span queries
Fuzzy, wildcard, and regular-expression matching for terms
Case and accent folding
COUNT(*) queries and BM25-scored top-k queries
A good text index in Postgres must support all of those things while also handling joins, complicated WHERE clauses across full-text and other column types, continuous updates, replication, backups, and correct transaction visibility.
... continue reading