I have a raster table in PostGIS. When I run ST_SetValue(rast, geom , value) on it to change the pixel value at a point, it works very slowly. Do you know how can I create spatial index for a raster column? (I could not create it using PgAdmin interface with gist method)
So when you are using
raster2pgsql raster_options_go_here raster_file someschema.sometable > out.sql, use
-I tag, that will create a GiST index on the raster column.
For more go here here