[postgis-tickets] [PostGIS] #4385: [raster2pgsql] -I option recreates index for each insertion

PostGIS trac at osgeo.org
Fri Aug 9 17:19:02 PDT 2019


#4385: [raster2pgsql] -I option recreates index for each insertion
--------------------------+---------------------------
  Reporter:  RaphJ        |      Owner:  Bborie Park
      Type:  enhancement  |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 2.5.4
 Component:  raster       |    Version:  2.4.x
Resolution:               |   Keywords:
--------------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS 2.5.3 => PostGIS 2.5.4


Comment:

 By insertion I presume you mean each append run.  Not for each individual
 tile?

 I haven't looked at this closely.  It should in theory fail if there is
 already an index on the table.  But it's also possible you do several
 append calls and then on your final commandline call you want to create
 the index on the table.  So seems perfectly legit to allow -I and a
 together.

 Anyway I'll push this to later once I've had time to test out all the
 scenarios

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4385#comment:1>
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-tickets mailing list