Opened 5 years ago

Closed 5 years ago

#2527 closed defect (fixed)

[raster] raster2pgsql needs a flag to skip band is NODATA check

Reported by: Bborie Park Owned by: Bborie Park
Priority: medium Milestone: PostGIS 2.1.1
Component: raster Version: 2.1.x
Keywords: history. Cc:

Description

I'm loading GRIB files as out-db rasters with 2.1.0 and hit a sub-optimal situation where the raster load takes forever.

ftp://tgftp.nws.noaa.gov/SL.us008001/ST.opnl/DF.gr2/DC.ndfd/AR.conus/VP.001-003/ds.wdir.bin

I need to double-check but from what I can tell, the problem has to do with rt_band_check_is_nodata(band).

The fix should be applied for both 2.0 and 2.1 as the loader hasn't changed much between versions.

Change History (3)

comment:1 Changed 5 years ago by Bborie Park

Status: newassigned

comment:2 Changed 5 years ago by Bborie Park

Since the raster is being loaded as out-db, a convenient work-around is to load the whole file as one raster and then use ST_Tile().

comment:3 Changed 5 years ago by Bborie Park

Keywords: history. added
Resolution: fixed
Status: assignedclosed

Fixed in trunk at r12092. Fixed in -2.1 in r12093. Doesn't need fixing in -2.0 as that version didn't have the check in place.

Note: See TracTickets for help on using tickets.