You can do to_tsvector “plain” and keep the strings intact. No lemming, stemming. We use plain tsvectors on a gin index and change the queries to allow prefix

You can do to_tsvector “plain” and keep the strings intact. No lemming, stemming. We use plain tsvectors on a gin index and change the queries to allow prefix based searching. So “wo he” matches “hello world”. Perhaps I should write a blog about it. Took me a few days to read PG documentation to get where we are at. The only thing it doesn’t handle is typo tolerance.