PSQL Search only works after inserting entire keyword

[arnerb]

Partial word text search

• It does not seem to work consistently for matching title, description or page content
  • inserting the entire keyword works (page is finally found)
• Searching subtstrings of URL paths: this seems to always work instead

Reproduce

Create a page at a random path (e.g. /test-page) and then edit as follows

• Title process
• Description process
• Content process

It will only be found when inserting the entire word, i.e. process in the search bar.

Searching pro or proces will not find the page

Question

Is this some speed tradeoff?

• I think at least title / description should be included for partial word search