Definition
TIN is planetscale’s GA Postgres full-text search access method using ctid-based postings, vectorized bitmap operations, and the ==> TINQL query operator.
Key Points
- Features: Boolean/phrase/span queries, fuzzy matching, wildcards, regex, bm25-ranking, MVCC-correct updates, hit highlighting
- Benchmarks (vendor): 2–16× faster index build; up to 541× query throughput vs GIN on 150M-doc corpus
- Companion: lead — TIN-compatible AGPL extension for CI/dev (full table scans, intentionally slow)
TIN is PlanetScale cloud-managed only as of Sep 2026 — not available for self-hosted Postgres.