this is actually literally insane because it doesn’t appear to have any trade-offs. it’s just better engineering.
the linked blog goes into detail about the implementation: mapping to CTIDs, various bitmaps, AVX, doing all this while they keep all the postgres constraints, etc.
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.