[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