Re: Index not being used

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Matthew Price <pricem(at)juno(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Index not being used
Date: 2002-02-14 23:08:45
Message-ID: 20020214150423.R24897-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Thu, 14 Feb 2002, Josh Berkus wrote:

> Matthew,
>
> 1. Is field cdate DATE or TIMESTAMP?
> 2. What happens with:
> EXPLAIN SELECT cdate FROM sometable WHERE cdate = '2001-02-14'::DATE or
> TIMESTAMP?
> 3. Please time both queries and give the number of resulting rows from
> both queries.

Something tells me that current_date is probably not in a form that's
considered indexable. You could probably get around that with an
iscachable function hiding it however.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-02-15 00:46:38 Re: Index not being used
Previous Message Josh Berkus 2002-02-14 22:38:00 Re: Index not being used