don't use GIN index, when i use =any

Поиск
Список
Период
Сортировка
От Laczi József
Тема don't use GIN index, when i use =any
Дата
Msg-id 49104B91.7050009@ritek.hu
обсуждение исходный текст
Список pgsql-general
Hi all!

I have a problem. I have a field with type: bigint[], and I create a GIN
index on it but don't use the index when i use '=any'.
When I try it with '<@' operator, then use index. I don't understand why
doesn't work with '=any'?
Does anybody knows why doesn't work it?

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Hot standby stops after a few days of inactivity (i.e. no new WAL)