Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Checking = with timestamp field is slow

Поиск
Список
Период
Сортировка
Hi all,
   I have a table which have more than 200000 records. I need to get
the records which matches like this

where today::date = '2004-11-05';

This is the only condition in the query. There is a btree index on the
column today.
Is there any way to optimise it.

rgds
Antony Paul

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