Re: Terribly slow query with very good plan?

[Nick Cleaton <nick@xxxxxxxxxxx>]

On Fri, 4 Feb 2022 at 12:27, Les <nagylzs@xxxxxxxxx> 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);