[postgis-users] Raster time-series data

[Tumasgiu Rossini]

Also maybe use COPY instead of INSERT statements
using -Y switch could speed up the process a bit.

2016-09-02 22:02 GMT+02:00 Robert Burgholzer <rburghol at vt.edu>:

> 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/
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160902/307292c4/attachment.html>