More Advanced Search

[A1Liu]

Split out from #121 :

• Partial word searches, or at least some kind of fuzziness
• Do some profiling; requests are still ~100ms

[A1Liu]

https://dba.stackexchange.com/questions/56224/postgresql-fts-and-trigram-similarity-query-optimization

[A1Liu]

https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/

[A1Liu]

term + tsvector GIN combined index? And rewrite queries to parse in Java so we can at least get prefix capabilities