Note: text_pattern_ops index is needed for prefix LIKE to be guaranteed-fast CREATE INDEX search_index ON items ((lower(data ->> 'name'::text)) text_pattern_ops);