TIN

TIN is a Postgres extension for full-text search. PlanetScale announced it on 16 September 2026, and it became available straight away on Postgres and Neki databases. It adds a search-specific inverted index inside the database, so teams that have outgrown Postgres's built-in text search do not need to run a separate search service. Each TIN index behaves like a normal Postgres index, with replication, backups and correct transaction visibility.

Features

• Search index: a TIN index created on a text column, for fast search.
• BM25 ranking: scores matching rows for relevance and returns the highest scoring results in order.
• TINQL: a query language with boolean operators, quoted phrases, fuzzy matching, wildcard prefixes and proximity queries.
• Lead: an open-source extension under the AGPL, for local development and CI, and not for production workloads.

Clients

Teams running PlanetScale Postgres or Neki databases that want search to stay consistent with their data.

Key facts

• Available on: PlanetScale Postgres and Neki databases
• Announced: 16 September 2026
• Benchmarks: published by PlanetScale itself, against ParadeDB, pg_textsearch and PostgreSQL's built-in GIN index