[postgis-tickets] [PostGIS] #5170: Make postgis raster copy rows configurable

[PostGIS]

#5170: Make postgis raster copy rows configurable
--------------------------+---------------------------
  Reporter:  robe         |      Owner:  robe
      Type:  enhancement  |     Status:  reopened
  Priority:  medium       |  Milestone:  PostGIS 3.3.0
 Component:  raster       |    Version:  master
Resolution:               |   Keywords:
--------------------------+---------------------------
Comment (by robe):

 Definitely faster with larger chunks.

 Timing for a 2g tif I was testing with 128x128 tiles

 # took 6 hrs
 {{{
 raster2pgsql -e -I -Y -t 128x128
 }}}

 # took 1.5 hrs
 {{{
 raster2pgsql -e -I -Y -Z 50000 -t 128x128
 }}}

 # took 1 hrs
 {{{
 raster2pgsql -e -I -Y -Z 100000 -t 128x128
 }}}

 @kompza preferred just ingesting the whole thing as default and using
 longer switches like --max-tiles-per-copy.

 I think switching to long aside from deviating from before is a much
 larger lift
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5170#comment:6>
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.