Quick Links

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

Re: Checking = with timestamp field is slow at 2004-11-05 08:14:01 from Michael Glaesemann
Re: Checking = with timestamp field is slow at 2004-11-05 08:34:01 from Michael Fuhr
Re: Checking = with timestamp field is slow at 2004-11-05 08:48:59 from Andrew McMillan
Re: Checking = with timestamp field is slow at 2004-11-05 12:47:54 from Christopher Browne

	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