We've gotten to play w/ TIN for a couple of months, and it's been a mind-blowing experience. Transformed (and eliminated a huge part of our search architecture). The performance is awesome but go look at how flexible the scoring is, literally can rank for absolutely any case
Today we introduce TIN: a powerful and reliable full-text search extension for Postgres.
TIN works with complicated WHERE clauses, replication, backups, and maintains correct transaction visibility.
It's also mind-blowingly fast.