What type of index do I need for this JOIN?

Поиск
Список
Период
Сортировка
От Robert James
Тема What type of index do I need for this JOIN?
Дата
Msg-id CAGYyBgjO1ci8Di7G7nqpR0Jwa+Oywwb4Hs-1QeDBaCgknrHpdA@mail.gmail.com
обсуждение исходный текст
Ответы Re: What type of index do I need for this JOIN?
Список pgsql-general
I'm doing a JOIN which is very slow:

JOIN t ON t.f1 LIKE (q.f1 || '%')

t1 has an INDEX on (f1, f2) which I thought would help for this.  But
Postgres seems to still use a (very slow) Nested Loop.  What type of
index would be appropriate for this?

(My goal is to join on a substring starting from the first character)


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

Предыдущее
От: Robert James
Дата:
Сообщение: Materializing a view by hand
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Performance of ORDER BY RANDOM to select random rows?