Checking = with timestamp field is slow

Поиск
Список
Период
Сортировка
От Antony Paul
Тема Checking = with timestamp field is slow
Дата
Msg-id 2989532e0411042316566b35f4@mail.gmail.com
обсуждение исходный текст
Ответы Re: Checking = with timestamp field is slow  (Michael Glaesemann <grzm@myrealbox.com>)
Re: Checking = with timestamp field is slow  (Michael Fuhr <mike@fuhr.org>)
Re: Checking = with timestamp field is slow  (Andrew McMillan <andrew@catalyst.net.nz>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Restricting Postgres
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Checking = with timestamp field is slow