Re: Terribly slow query with very good plan?

Поиск
Список
Период
Сортировка
От Nick Cleaton
Тема Re: Terribly slow query with very good plan?
Дата
Msg-id CAFgz3kt-2mhWONWbYM_6uLSO2JLVkZxacdr+cThyehvikZwV1Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Terribly slow query with very good plan?  (Les <nagylzs@gmail.com>)
Ответы Re: Terribly slow query with very good plan?  (Les <nagylzs@gmail.com>)
Список pgsql-performance
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);



В списке pgsql-performance по дате отправления:

Предыдущее
От: Les
Дата:
Сообщение: Re: Terribly slow query with very good plan?
Следующее
От: Les
Дата:
Сообщение: Re: Terribly slow query with very good plan?