indexing datetime - Mailing list pgsql-sql

From Sergei Barbarash
Subject indexing datetime
Date
Msg-id 199809020707.LAA22700@zaraza.dot.ru
Whole thread Raw
List pgsql-sql
I have a very large and fast-growing table with a datetime field. Most of my
queries are based on date comparison as well. Like:

select * from table where time > 'Aug 1 0:0:0 1998' and time < 'Sep 1 0:0:0
1998';

How can I index the table to optimize my queries? Or maybe datetime is a bad
choice for this?

-- Sergei



pgsql-sql by date:

Previous
From: David Hartwig
Date:
Subject: Re: [SQL] How to Make Case InSensitive???
Next
From: Sferacarta Software
Date:
Subject: Re: [SQL] upper() and lower() on varchar