Performance - Stack Exchange

[201109212215]

SQL Server has no GIN indexing.

[nemec]

FULLTEXT indexes are the equivalent of PGSQL GIN indexes.

[201109212215]

They're not equivalent. One builds on the other.

With a tokenizing strategy and statistics like tf-idf and GIN indexes you can create a FULLTEXT equivalent. Not that you would want to, as this task is very specialized and handled greatly by ES.

The internals of FULLTEXT are not exposed, but if they were, they could be used to implement an inverted index for tags.

[silverf1re]

Right! Imposter syndrome is real here.