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

PostGIS trac at osgeo.org
Sun Jun 21 07:06:11 PDT 2026


#4385: [raster2pgsql] -I option recreates index for each insertion
--------------------------+-----------------------------
  Reporter:  RaphJ        |      Owner:  dustymugs
      Type:  enhancement  |     Status:  closed
  Priority:  medium       |  Milestone:  PostGIS Fund Me
 Component:  raster       |    Version:  2.4.x
Resolution:  fixed        |   Keywords:
--------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"6884c2be41810eb4d02a1d0f88ca61439024f827/git" 6884c2b/git]:
 {{{#!CommitTicketReference repository="git"
 revision="6884c2be41810eb4d02a1d0f88ca61439024f827"
 Clarify raster2pgsql index creation timing

 Document that -I and --create-index create the spatial index at the end of
 each raster2pgsql run, so repeated append batches should create the index
 only on the final run or create it manually after loading.

 Group related loader argument NEWS entries and use bounded formatting for
 the generated CREATE INDEX SQL while updating the same code path.

 Closes #4385

 Closes https://github.com/postgis/postgis/pull/1031
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4385#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.


More information about the postgis-tickets mailing list