[postgis-devel] temporal indexing

[Elena Camossi]

Hi list,

I'm designing a spatio-temporal schema with support for coverage and
temporal data in postgresql by using postgis spatial extension. The temporal
support so far is quite limited,  just timestamps which state the time at
which data have been collected. Anyway, the temporal information is
extensively used to access data, so the corresponding fields should require
an index.

The scientific literature states that R-Tree perform quite well with this
kind of data, but there exist other indexes that should perform better.
Does anyone in the list has some previous experience on using GiST postgres
implementation for indexing postgresql temporal columns? Does anyone extend
the GiST operator classes with specific support for temporal data?

Thank you for helping.

Best regards,
-Elena
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20070807/2b95dc09/attachment.html>