<div dir="ltr">Also maybe use COPY instead of INSERT statements <br>using -Y switch could speed up the process a bit.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2016-09-02 22:02 GMT+02:00 Robert Burgholzer <span dir="ltr"><<a href="mailto:rburghol@vt.edu" target="_blank">rburghol@vt.edu</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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. <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"></blockquote>
<div>Hth - robert</div><span class="HOEnZb"><font color="#888888"><br><br>-- <br><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.'  - Charles Mingus<div>Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://<wbr>athleticalgorithm.wordpress.<wbr>com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.<wbr>wordpress.com/</a></div><div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.<wbr>wordpress.com/</a></div></div><br>
</font></span><br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>