Hi list,<br><br>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.
<br><br>The scientific literature states that R-Tree perform quite well with this kind of data, but there exist other indexes that should perform better.<br>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?
<br><br>Thank you for helping.<br><br>Best regards,<br>-Elena <br>