Trigram index for LIKE name queries

[Mike Kulakovsky]

Have you considered enabling pg_trgm for "%name%" searches? 

Full-text tsquery often fails on non-dictionary words, and especially it is noticable on domain names. On crt.sh I get a lot of missing search results when querying like "wordstogether". 

I've encountered this kind of problem in the past and I replaced tsquery with pg_trgm. It worked very well. The index is quite large, though.

[r...@sectigo.com]

Hi Mike.  I did play with pg_trgm a few years ago.  IIRC, it was just too slow for crt.sh's use cases.

I agree that Full Text Search isn't a perfect fit for crt.sh, but I'm yet to find time to do an exhaustive review on the available alternatives.