PlanetScale's TIN beats Postgres GIN full-text search: 212ms vs 288s at p99
DanielLockyer · x · 2026-09-18
PlanetScale has introduced TIN, a full-text search extension for Postgres, and a developer benchmark is turning heads: the same query clocks in at a p99 of 212 milliseconds on TIN versus a staggering 288 seconds with Postgres's built-in GIN index — a three-orders-of-magnitude gap.
TIN works with complicated WHERE clauses, replication, and backups, while maintaining correct transaction visibility. Given how widely GIN has been used for Postgres full-text search, the result suggests many production setups may be worth revisiting.
More from Infra
- Ben Bajarin argues compute is becoming fungible as hyperscalers redesign data center economics — BenBajarin · 2026-09-18
- LLM Studio: free Android app runs LLMs offline, generates images and turns your phone into an AI server — Miserable_Bird5822 · 2026-09-18
- fal made an open-source video model 35x faster — and Hollywood became its fastest-growing segment — a16z · 2026-09-18
- AMD plans ~10% price hike across GPUs, chipsets, and possibly CPUs — FullstackSensei · 2026-09-18
- Dev Builds 'Local ChatGPT in a Box' on One RTX 5090, Sharing Every Workaround Along the Way — valdev · 2026-09-18
- King Charles Meets OpenAI, Anthropic, DeepMind and Nvidia Execs on AI Safety — eyishazyer · 2026-09-18