Introducing TIN for PostgreSQL 🤟
PlanetScale just introduced a new type of the full text search index, which they claim to be blazingly fast. While the traditional engines like Lucene use the artificial document ids; doing a native full text search to Postgres allows to use ctid - physical tuple id, which claimed to significantly improve performance. Not without problems though: follow the article for the details.

#db #performance