From: Antony Paul <antonypaul24@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Checking = with timestamp field is slow
Date: Fri, 5 Nov 2004 12:46:20 +0530
Message-ID: <2989532e0411042316566b35f4@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: antonypaul24@gmail.com
Subject: Re: Checking = with timestamp field is slow
In-Reply-To: <2989532e0411042316566b35f4@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox