[postgis-users] Raster time-series data

Robert Burgholzer rburghol at vt.edu
Fri Sep 2 13:02:12 PDT 2016


I wonder if it is getting slower because of the date query that you're
doing?  You may try indexing raster_date field.  Putting an index on that
might slow down inserts but it would improve updates.  I would certainly
expect that your updates would get slower overtime for a non-indexed date
match.
>
> Hth - robert


-- 
--
Robert W. Burgholzer
 'Making the simple complicated is commonplace; making the complicated
simple, awesomely simple, that's creativity.'  - Charles Mingus
Athletics: http://athleticalgorithm.wordpress.com/
Science: http://robertwb.wordpress.com/
Wine: http://reesvineyard.wordpress.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160902/1a8c5e15/attachment.html>


More information about the postgis-users mailing list