[postgis-devel] [PostGIS] #1696: [raster] raster2pgsql fails with big raster on Windows

PostGIS trac at osgeo.org
Mon Mar 19 08:57:38 PDT 2012


#1696: [raster] raster2pgsql fails with big raster on Windows
----------------------+-----------------------------------------------------
  Reporter:  pracine  |       Owner:  pramsey      
      Type:  defect   |      Status:  closed       
  Priority:  medium   |   Milestone:  PostGIS 2.0.0
 Component:  postgis  |     Version:  trunk        
Resolution:  wontfix  |    Keywords:               
----------------------+-----------------------------------------------------
Changes (by dustymugs):

  * status:  new => closed
  * resolution:  => wontfix


Comment:

 I expect that to fail.  Everything of raster2psql makes use of the
 functions provide in rt_api, where all functions operate in memory.  As
 such, if that raster was in the database, it would also fail when any
 database operation is done on it.

 As to where memory is being consumed in the loader...

 1. GDAL natural block (some subset of the raster)

 2. postgis raster internal data structure (full raster)

 3. hexwkb of step #2 (full raster x2 as hex is twice the size of the
 binary raster)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1696#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list