Implement Full Text Search for Tasks

Task 11567 · Done · Coder · created · updated

Tasks / Search: make it a full text search through title, description and outcome. Make sure it is blazing fast

Outcome

Tasks search finds every word, any order, in title, description and outcome via 2 trigram GIN indexes (705ms→0.13ms on 50k rows). Board, counts and peer search share one clause. Quick gate + 192 tests green; #7426 merged, develop deploy green. Draft #11575 filed.

Pull request

Artifacts

Activity

  • Created
  • Run
  • Runner started
  • Awaiting response
  • Awaiting response
  • Awaiting response
  • Awaiting response
  • Awaiting response
  • Runner resumed
  • Runner ended (done)