[postgis-users] import raster

Eloi eloi at openmailbox.org
Thu Feb 27 02:03:34 PST 2014


Hi all,

My SELECT PostGIS_Full_Version() is: "POSTGIS="2.0.3 r11128" 
GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 
1.10.0, released 2013/04/24" LIBXML="2.9.0" LIBJSON="UNKNOWN" RASTER"

I am importing a GeoTIFF (1 band, Type = Byte,  Not Compressed file size 
= 933.5 MB, columns/rows 43200, 21600, Pixel Size = 
0.008333333333333,-0.008333333333333) into PostGIS and is taking more 
than one hour by now. Is that normal?

This is the command I have used:
raster2pgsql -s 4326 -d -I -C -M -t 5x5 /path/file_name.tif 
schema_name.table_name|psql -d db_name

Yes, very small tiles. The goal is to intersect this raster with point 
features. But the issue right now is the import it self that is taking 
to much time.
I can see now that the first 1:30 were for inserts and now is starting 
with the constraints. Is this the normal speed or am I missing 
something?

Thanks. Cheers,

Eloi


More information about the postgis-users mailing list