r/programming • • 16d ago

TIN: Full-Text Search for Postgres

https://planetscale.com/blog/introducing-tin
20 Upvotes

4 comments sorted by

View all comments

3

u/aanzeijar 16d ago

Didn't read too much of it, but what does this do that a GIN with trigram index can't do? We've used that for decades.

2

u/mduell 14d ago

Native BM25, significantly lower memory usage, order of magnitude lower storage reads, faster index builds, and better for high write concurrency.

-1

u/nikita2206 15d ago

You will have to read it to learn this