[postgis-users] loading raster into DB takes more then an hour

[Pierre Racine]

And CPU and hard drive types? I get very different times on different machines for the same dataset.

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Bborie Park
> Sent: Monday, September 17, 2012 2:55 PM
> To: postgis-users at 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 at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> --
> Bborie Park
> Programmer
> Center for Vectorborne Diseases
> UC Davis
> 530-752-8380
> bkpark at ucdavis.edu
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users