Skip to main content
1 of 8
Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620

You forgot to mention that you installed the additional module pg_trgm, which provides the similarity operator. Details:

The basic index you need is a GiST index using the special operator class gist_trgm_ops:

CREATE INDEX trgm_idx ON lcas USING gist (job_title gist_trgm_ops);

This can probably be improved further, depending on missing information ... that you just now added. No more time now, I'll come back to this later ...

Erwin Brandstetter
  • 182.2k
  • 28
  • 457
  • 620