[postgis-devel] temporal indexing

[Decibel!]

On Tue, Aug 07, 2007 at 10:19:27AM -0700, Chris Hodgson wrote:
> If you're only querying based on date then a standard b-tree index on 
> the date itself should provide reasonable performance.

Actually, querying for rows within a specific date range can be very
slow with a btree in some cases (though I think bitmap scans improves
that a lot).

There's also a tinterval data type that's undocumented, which may be of
use.
-- 
Decibel!, aka Jim Nasby                        decibel at decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20070809/77cc8e93/attachment.sig>