Use of to_timestamp causes full scan

Поиск
Список
Период
Сортировка
От Zaremba, Don
Тема Use of to_timestamp causes full scan
Дата
Msg-id E3A785CF5322D611A20D0003474E0C3C9B5DCF@postal.ellacoya.com
обсуждение исходный текст
Ответы Re: Use of to_timestamp causes full scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Has anyone seen any performace problems with the use to to_timestamp?

When I use it in a where clause I get a full file scan, when I  don't it
uses the index
for the query. The begin_time column is of type timestamp.

This does a full sequential scan
    select id from details where begin_time > to_timestamp('03/08/25
18:30');


This uses the index
    select id from details where begin_time > '03/08/25 18:30';

Don


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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Use of to_timestamp causes full scan