Checking = with timestamp field is slow - Mailing list pgsql-performance

From Antony Paul
Subject Checking = with timestamp field is slow
Date
Msg-id 2989532e0411042316566b35f4@mail.gmail.com
Whole thread Raw
Responses Re: Checking = with timestamp field is slow
Re: Checking = with timestamp field is slow
Re: Checking = with timestamp field is slow
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Restricting Postgres
Next
From: Michael Glaesemann
Date:
Subject: Re: Checking = with timestamp field is slow