1 link tagged with all of: postgres + full-text-search + performance-benchmarks + database-indexing
Click any tag below to further narrow down your results
Links
PlanetScale released TIN, a new full-text search index for Postgres that handles boolean queries, fuzzy matching, BM25 ranking, and concurrent writes—capabilities existing Postgres search tools lack. In benchmarks against competitors, TIN processed 25-541x more queries per second with dramatically lower latency.
- TIN supports boolean expressions, phrase queries, fuzzy/wildcard/regex matching, BM25 scoring, and handles concurrent updates—a combination no existing Postgres full-text index provides
- Benchmark results show TIN handles 25x more queries/second than ParadeDB and 541x more than Postgres GIN on mixed workloads, with p99 latencies 26-1,356x lower
- With concurrent writes, TIN completed 270,279 updates over 10 minutes while ParadeDB managed 185,584 and pg_textsearch only 735, showing it doesn't sacrifice write performance for read speed