[postgis-devel] shp2pgsql defaults

Regina Obe lr at pcorp.us
Mon Mar 2 15:02:56 PST 2020


I think we changed it in 3.0 so force srs transformation does not require slow INSERT anymore. Can use copy mode.
Yes +1 for defaulting to fast load and index (except when called in append mode).



> -----Original Message-----
> From: postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] On
> Behalf Of Paul Ramsey
> Sent: Monday, March 2, 2020 5:47 PM
> To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> Subject: [postgis-devel] shp2pgsql defaults
> 
> Two defaults have bothered me over the years:
> 
> - the default load format is not dump, it�s insert, which is way way slower,
> we should default to the fast one and only drop out of that in cases were we
> have to (like forced srs transformation)
> - the default is to not build indexes, which mostly we always want, we should
> default to building indexes
> 
> Anyone get heated up over the idea of changing those defaults?
> 
> P
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list