Re: The type int8 and the use of indexes

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: The type int8 and the use of indexes
Дата
Msg-id Pine.BSF.4.21.0101251509180.86621-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на The type int8 and the use of indexes  (nelson@radix.com.br)
Ответы Re: The type int8 and the use of indexes
Список pgsql-general
On Thu, 25 Jan 2001 nelson@radix.com.br wrote:

>
>    Hi,
>
>    I realized that PostgreSQL (7.0.3) optimizer doesn�t use indexes in a query
> like "select * from my table where pk=1", where the field pk is of
> type int8.
> I changed the type to int4, and now it uses the index (a lot faster). I also
> tryed changing the type to numeric, with the same results.
>    Why does it happen? Is there something special with type int8 ???

Forgot about that. :(
The reason is that the 1 is being treated as an int4 and it's not smart
enough to realize it can use the int8 index for the search.

select * from table where pk=1::int8 should use the index if pk is an
int8 column.


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

Предыдущее
От: nelson@radix.com.br
Дата:
Сообщение: The type int8 and the use of indexes
Следующее
От: Steve Leibel
Дата:
Сообщение: timestamp calculations