Re: Any "guide to indexes" exists? - Mailing list pgsql-general

On Mon, May 07, 2007 at 10:47:24AM -0500, Jim Nasby wrote:

> GiST can also be useful if you have to query in multiple dimensions,
> which can occur outside the normal case of geometry. Best example I
> know of is a table containing duration information in the form of
> start_time and end_time. Trying to query for what events happened on
> 5/28/2005 will generally be much cheaper with a GiST index than a b-
> tree.
Are you referring to queries with

    ... where some_timestamp between some_start and some_end ...

or

    ... where some_timestamp > some_start and some_timestamp < some_end ...

?

Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346