[postgis-tickets] [PostGIS] #4402: raster2pgsql debug methods needed, GEOTIFF stalling for hours on addrasterconstraints

[PostGIS]

#4402: raster2pgsql debug methods needed, GEOTIFF stalling for hours on
addrasterconstraints
----------------------+-----------------------------------------------
  Reporter:  osgeoap  |      Owner:  Bborie Park
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.0
 Component:  raster   |    Version:  2.4.x
Resolution:           |   Keywords:  addrasterconstraint, raster2pgsql
----------------------+-----------------------------------------------
Changes (by robe):

 * milestone:  PostGIS 2.4.8 => PostGIS 3.0.0


Comment:

 It's hard to tell what the culprit is at anyrate outputting timing of what
 addraster contraints is doing I think would be useful.

 addrastercontraints should probably also be changed to a stored procedure,
 but that requires PostgreSQL 11 or above, so will probably need to wait.
 That way it doesn't have to commit all the constraints in one batch, which
 is partly why it's slow.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4402#comment:3>
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.