ines_data Searching deploy finds deploying, but depl finds nothing.
Tried ilike '%depl%'. Works but slow at 100k rows.
That's how full-text works: stems, not prefixes. For prefix search use to_tsquery('depl:*'), or combine full-text with pg_trgm and a GIN index on the text column for the 'as you type' case. This forum does exactly that: tsvector for ranked results, trigram as a fallback.
Numbers from a 120k-row table I had lying around, so you can see what the trigram index buys you for ilike:
create extension if not exists pg_trgm;
create index articles_body_trgm on articles using gin (body gin_trgm_ops);Your existing ilike '%depl%' query uses it without changes. Needs at least 3 characters to be useful.
ines_data