PostGIS: ST_Clip() raster in SRID:32617 with a polygon

Question

I'm trying to ST_Clip() raster in `SRID:32617' with a polygon.
What I did

• ST_Transform(polygon, 32617): It fails, couldn't project point() exceeded limit (-14)
• ST_Transform(rast, 4326, 'NearestNeighbor'): It runs really slow (more than 700,000,000 ms, then I terminated before it finished) about 1300 rasters (tiles)

My polygon got lon/lat from Google map:

ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 105.78873 20.71758, 
106.49185 20.71758, 105.78873 21.38659))', 4326)

I'm using postGIS 2.1

UPDATE:
My raster is retrieved from Landsat8. I downloaded the raster from earthexplorer.usgs.gov
The raster is imported into postGIS by raster2pgsql with tile-size 500x500, SRID is kept as original (32617,32617, 32632, 32648, 32649, 32658, 32659, 32660))

UPDATE:
Here's Map projection in metadata text of one scene.

GROUP = PROJECTION_PARAMETERS
MAP_PROJECTION = "UTM"
DATUM = "WGS84"
ELLIPSOID = "WGS84"
UTM_ZONE = 49
GRID_CELL_SIZE_PANCHROMATIC = 15.00
GRID_CELL_SIZE_REFLECTIVE = 30.00
GRID_CELL_SIZE_THERMAL = 30.00
ORIENTATION = "NORTH_UP"
RESAMPLING_OPTION = "CUBIC_CONVOLUTION"
END_GROUP = PROJECTION_PARAMETERS

UPDATE The polygon above is invalid. Here's correction: ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 106.49185 20.71758, 105.78873 20.71758, 105.78873 21.38659))', 4326)

Answer 1

That spatial reference identifier (32617) is in UTM Zone 17N (which is in the US). It makes no sense at all to try to project something at 106E to Zone 17N (78W to 84W) coordinates.

You probably want to use something like UTM Zone 48N: http://spatialreference.org/ref/epsg/32648/

SELECT AsEwkt(ST_Transform(ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 105.78873 20.71758, 106.49185 20.71758, 105.78873 21.38659))', 4326), 32648));
SRID=32648;POLYGON((581760.7532212715 2365138.811852233,654656.3711929469 2365667.925132345,582126.9328327369 2291091.94133294,655349.2256348798 2291607.543684119,581760.7532212715 2365138.811852233))

[I used spatialite, but postgis will likely look similar]

Now you might have rasters in another UTM zone, but you can probably assume that if the srid doesn't match, then the raster is in another UTM zone and it won't match any polygon in this UTM zone.