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 Christopher Browne <cbbrowne@acm.org>
Re: Checking = with timestamp field is slow Michael Fuhr <mike@fuhr.org>
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 по дате отправления