[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