[postgis-tickets] [PostGIS] #4385: [raster2pgsql] -I option recreates index for each insertion
PostGIS
trac at osgeo.org
Fri Apr 26 10:13:36 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.3
Component: raster | Version: 2.4.x
Keywords: |
-------------------------+---------------------------
raster2pgsql
The "-I" option does not make it clear that it recreates index for each
insertion, which leads to poor performance for batch inserts (x10 slower).
I've seen confusion about it on tutorials and on StackOverflow.
Could you please update the doc (man page and onlin) or even disable it
(or output a warning) when used together with -a option (append).
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4385>
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