Re: [postgis-users] raster2pgsql: -t TILE_SIZE

2015-03-16 Thread Stephen Mather
Hi Ramon, I am not an expert on this by any measure. Better to check with the postgis user group (cc'd). I know the better size choices have changed a lot since Bborie optimized / rewrote in C. Best, Steve On Mar 16, 2015 4:24 AM, "Ramon de Leon" wrote: > > Hi Steve, > > Hope you are doing

Re: [postgis-users] raster2pgsql: -t TILE_SIZE

2015-03-16 Thread Bborie Park
Ramon, It really depends on whether the rasters are stored in the database (in-db) or out of the database (out-db) If out-db, I recommend using the block size returned when running gdalinfo on the raster... # gdalinfo raster/test/regress/loader/testraster.tif Driver: GTiff/GeoTIFF Files: raster/

Re: [postgis-users] raster2pgsql: -t TILE_SIZE

2015-03-16 Thread Pierre Racine
> If you're storing the raster in the database, I have no specific suggestions. > The reason for no suggestion is that it really depends on the characteristics > of the raster (number of bands, pixel type of each band) and the server > environment. You normally want to store in-db because you want