On Fri, 4 Feb 2022 at 12:27, Les <nagylzs@gmail.com> wrote:
> PostgreSQL uses seq scan for O, F, N, T letters, but it uses index scan for A, I, C letters (with the "like" query).
That's interesting.
Does it help if you create an additional index on relpath with the
text_pattern_ops modifier, e.g.
CREATE INDEX ... USING btree (relpath text_pattern_ops);