Checking = with timestamp field is slow

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Checking = with timestamp field is slow
Date: 2004-11-05 07:16:20
Message-ID: 2989532e0411042316566b35f4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Glaesemann 2004-11-05 08:14:01 Re: Checking = with timestamp field is slow
Previous Message Bruno Wolff III 2004-11-05 05:16:46 Re: Restricting Postgres