[postgis-devel] [raster] Memory management and IO concerns

[Pierre Racine]

> > Actually, I've already hit something else which may be a more stringent limit:
> > when trying to load a single band of a Landsat image (not tiled,
> > loaded as a single raster), I got an out of memory error. I assumed
> > this was in the parser, as the SQL file generated by raster2pgsql.py
> > used a single "INSERT" statement to plop in the entire 64Mb binary
> > image. I hadn't thought of this before, but large rasters may need to
> > be loaded via many "ST_SetRasterDataBlock" calls rather than one INSERT.
> 
> This looks like a real issue (as the limit should be 1 GB). You should fill a ticket for
> that.

Just loaded a 55MB landsat in one table row without problem. My code is a bit out of date though and I don't want to update it now. It might be a new introduced bug.

Pierre