And CPU and hard drive types? I get very different times on different machines for the same dataset.
> -----Original Message----- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Bborie Park > Sent: Monday, September 17, 2012 2:55 PM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] loading raster into DB takes more then an hour > > Yes, no and maybe. You haven't given sufficient information about your > environment to provide any informed advice. > > What is your raster2pgsql command? > > Are you piping the output from raster2pgsql directly to psql? Or > loading from a file containing the output? > > What OS? PostgreSQL version? > > -bborie > > On 09/17/2012 09:10 AM, G. Allegri wrote: > > I'm loading a DEM (float, single band, 27654x17623) through raster2pgsql > > and it takes more then hour to complete. > > It happens both with tiled loading (256x256) and single block. > > Is it normal? > > > > giovanni > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
