[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