[postgis-tickets] [PostGIS] #4628: Add an option to disable ANALYZE when loading shapefiles

PostGIS trac at osgeo.org
Tue Jan 28 03:09:16 PST 2020


#4628: Add an option to disable ANALYZE when loading shapefiles
--------------------------+---------------------------
 Reporter:  gravitystorm  |      Owner:  pramsey
     Type:  enhancement   |     Status:  new
 Priority:  low           |  Milestone:  PostGIS 2.5.4
Component:  postgis       |    Version:  2.5.x
 Keywords:                |
--------------------------+---------------------------
 After r13832 (ticket #2562) sh2pgsql automatically runs ANALYZE after
 loading a shapefile. This is a great default, but can cause problems when
 loading tens of thousands of shapefiles (e.g. from DEM processing) since
 the ANALYZE is run over and over again unnecessarily.

 It would be nice to have an option to disable the ANALYZE in situations
 where you know you will be adding shapefiles repeatedly to the same table.

 A workaround is to edit the output from shp2pgsql and remove the ANALYZE
 statement.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4628>
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