[postgis-users] Raster time-series data

[Robert Burgholzer]

And further, waiting to set the date default on nulls until after the
entire import completed could help too (if your requirement will
allowmthat).

On Friday, September 2, 2016, Robert Burgholzer <rburghol at vt.edu> wrote:

> 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/
>
>

-- 
--
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/ffb5a346/attachment.html>