Re: indexing timestamp fields - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: indexing timestamp fields
Date
Msg-id 20031016165629.GA28009@wolff.to
Whole thread Raw
In response to Re: indexing timestamp fields  (teknokrat <teknokrat@yahoo.com>)
List pgsql-sql
On Wed, Oct 15, 2003 at 21:25:17 +0100, teknokrat <teknokrat@yahoo.com> wrote:
> 
> I have a lot of queries of the " where timestamp < some date " type and 
> was wondering if an index would improve performance. None of the 
> timestamps are null and they are always populated

Unless that query returns only a small fraction of the table (which would
be unusual for a before some date restriction) or you order by the date,
an index probably won't help.


pgsql-sql by date:

Previous
From: teknokrat
Date:
Subject: indexing timestamp fields
Next
From: "Muhyiddin A.M Hayat"
Date:
Subject: Re: Calc