Re: [GENERAL] jsonb case insensitive search

Поиск
Список
Период
Сортировка
От Guyren Howe
Тема Re: [GENERAL] jsonb case insensitive search
Дата
Msg-id 066ECF7C-8C9D-45F5-A7BA-3FC31870C071@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] jsonb case insensitive search  (Karl Czajkowski <karlcz@isi.edu>)
Список pgsql-general
Дерево обсуждения
On Jun 1, 2017, at 13:44 , Karl Czajkowski <karlcz@isi.edu> wrote:
If I remember correctly, isn't a compound index always just using
btree?  In general, I have found better luck using several smaller
btree indices than one large compound one.  Unless your entire query
can be answered from an index-only lookup, the extra columns just
bloat the btree index.

The issue is *much* more subtle than this. For repetitive queries, a compound index can be a great speedup.

Best discussion I’ve seen around index design is on the website use-the-index-luke.com.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] repmgr cascade replication node delay
Следующее
От: "Wetzel, Juergen (Juergen)"
Дата:
Сообщение: Re: [GENERAL] Slow query plan used