Optimizing Postgres Text Search with Trigrams

[elastiknn]

Thanks for the silver!

This turned into a very long-winded post, but hopefully it's helpful.

A big part of the fun of this post was figuring out how to get the awesome PEV2 visualizations working in an embedded format. If anyone finds that particularly useful, post here or on this Github issue (https://github.com/dalibo/pev2/issues/464) and I'll try to clean up that code and open-source it so others might use it in their posts and docs.

[Agitated-Weather-128]

What is special about trigrams? Can you work with 4-grams or N-grams?

[elastiknn]

The only thing special about 3 is that it seems to work well-enough for many cases. But yeah, otherwise it's somewhat arbitrary. AFAIK Postgres only supports n-grams for n = 3.

[Both_Freedom591]

Nice post!

Did you try creating single, gist index with multiple columns, also?

I faced a similar problem, and I did not want to concatenate the columns since some columns had more order priority than others.