Tin: full-text search for Postgres
- Source
- planetscale.com
- Author
- ksec
- Date
PlanetScale released Tin, a general-availability full-text search extension for Postgres. It supports boolean, phrase, fuzzy, and BM25-ranked queries while keeping correct MVCC transactional visibility, a property bolt-on search engines like Elasticsearch do not share with the source database. The team credits three specific design choices for the speed gain over existing Postgres text search: 48-bit document IDs that keep the index compact, work elision that skips redundant scoring work, and segment merging that keeps the index from fragmenting under continuous writes. For teams currently running a separate search service purely to get ranked full-text queries, a native, transactionally consistent option inside Postgres removes an entire piece of infrastructure and the sync lag that comes with it.

Context
Database provider PlanetScale says its text-index extension, TIN, lets applications search text inside Postgres while using ordinary database filters and joins in the same query. The company describes it as supporting both relevance-ranked results and exhaustive matching, such as finding every document containing specified words.
The integration matters when the underlying records change. PlanetScale says search results reflect committed updates and respect transaction visibility, the rules governing which database changes a query can see. That makes the contribution broader than a faster keyword lookup: text search participates in the database's handling of changing application data.
Checking sign-in…
Loading comments…

