[postgis-users] Postgis raster : storage performance ?

[Bborie Park]

The key difference between out-db and in-db is that in-db rasters can be
modified.  Out-db is read-only (and will most likely never be modifiable
due to file format and file system issues).

I do recommend using out-db when the source rasters are immutable and
contain a large number of bands (such as a model output raster file with
one band per day).  In testing, the performance differences are harder
to quantify due to different hardware setups (how much data?  how many
spindles?  how much RAM?).  I get different results when using my
production database servers vs smaller dev-oriented servers.

PostGIS has no problems with out-db compressed rasters.  As long as GDAL
supports it, PostGIS supports it.  As for in-db, the raster format lets
PostgreSQL decide if the data should be compressed.

-R instructs raster2pgsql to load the source rasters as out-db.  This
means that instead of storing the rasters themselves in the database,
only the source raster's full path is stored.

-bborie

On 01/11/2013 02:07 AM, laurent wrote:
> Hello,
> 
> 1/ Is there a real advantage to import raster into postgis db in storage
> purposes? Can you give me an indicator evaluating  the gain of file size
> compared to raw raster files?
> 
> 2/ Is there a postgis raster tool for compressing raster cover in order to
> compress the size of the dbs? 
> 
> 3/ Could you explain to me the -R (register) postgis optional parameter ?
> What is the interest of this parameter? 
> 
> 
> Thank you to throw light for me? 
> 
> Kind regards. 
> 
> ~IMAGE~
> 
> 
> 
> 
> --
> View this message in context: http://postgis.17.n6.nabble.com/Postgis-raster-storage-performance-tp5002222.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu