index not used for bigint without explicit cast

Поиск
Список
Период
Сортировка
От Sam.Mesh
Тема index not used for bigint without explicit cast
Дата
Msg-id CACi6F2nKR=5Tt21jwXcw2PAF_hfQfV7czvY92NT6onTUgR3=tw@mail.gmail.com
обсуждение исходный текст
Ответы Re: index not used for bigint without explicit cast
Список pgsql-bugs
Hello,

"index not used for bigint without explicit cast" is very old limitation mentioned in 2003 at

Here is more recent mention of similar limitation in 2021
***
The problem arrises with the other case, where the values from the table are to be converted to match the datatype of the query (i.e., we give numeric in query and the column is of bigint type). As Postgres can only cast a bigint to numeric, the only option it has is to convert every row in the table to numeric and then compare. Thus in this case, the index won’t be used.
***

Probably, somebody knows the current state of this limitation?

Thanks,
Sam

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: BUG #17741: vacuum process hangs after pg_surgery manipulations
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: index not used for bigint without explicit cast