Postgres Pro
Downloads
Home   >   mailing lists

Re: Index not being used - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Index not being used
Date
Msg-id web-694398@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Index not being used  (Matthew Price <pricem@juno.com>)
Responses Re: Index not being used  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Tree view 
Matthew,

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

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco

pgsql-sql by date:

Previous
From: Matthew Price
Date:
Subject: Re: Index not being used
Next
From: Stephan Szabo
Date:
Subject: Re: Index not being used