PostGIS - Raster - update all values - what is prefered

[المشرف العام]

I have added the Raster support to my PostGIS database program. Now, I need to update all values in the raster (one band only) several times a day.

I have found and tested these two options

• Use ST_SetValues (http://postgis.net/docs/manual-2.1/RT_ST_SetValues.html)
• Use WKB and do UPDATE table SET rast = 'wkb_data_string'; (code extracted from http://www.postgis.org/documentation/raster-doxygen/dd/d23/rt__api_8c-source.html)

Both methods works fine with same results, speeds according to my tests seems also almost the same (but I may have done some errors there).

What is a better way from those twos, or is there some third option?



أكثر...