Re: BUG #15861: jsonb exists query retuning inconsistentresults

Поиск
Список
Период
Сортировка
От RJ Ewing
Тема Re: BUG #15861: jsonb exists query retuning inconsistentresults
Дата
Msg-id d4db87a2-862c-4bb1-a6b1-211d52c77008@Spark
обсуждение исходный текст
Ответ на Re: BUG #15861: jsonb exists query retuning inconsistent results  (Sergei Kornilov <sk@zsrv.org>)
Список pgsql-bugs
Дерево обсуждения
Ya, that is most likely the issue. I have the gin_fuzzy_search_limit set to 15k.

Is there a way around this? Having a search limit of 15k seems reasonable to me when doing a FTS, however I would not want that limit when doing an exists query. Any way to tell the planner to not use the index? Or other alternative?

Thanks

RJ Ewing
On Jun 19, 2019, 11:56 PM -0700, Sergei Kornilov <sk@zsrv.org>, wrote:
Hello

Please check your gin_fuzzy_search_limit setting: https://www.postgresql.org/docs/current/gin-tips.html
Seems this setting is in effect.

regards, Sergei

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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Logging corruption error codes
Следующее
От: Sergei Kornilov
Дата:
Сообщение: Re: BUG #15861: jsonb exists query retuning inconsistent results