[postgis-devel] shp2pgsql multi-transaction INSERT mode

Sandro Santilli strk at keybit.net
Fri Jul 18 04:38:24 PDT 2014


On Fri, Jul 18, 2014 at 01:32:34PM +0200, RĂ©mi Cura wrote:
> Cool !
> That's probably why it is the fastest way to load shp (faster than gdal).
> B-)
> 
> For big data I would bet that it is fastest to load with copy then
> reproject with transform in base.

Tests and patch welcome. There's indeed no reason why a final
UPDATE should not be performed after the copy.

--strk;



More information about the postgis-devel mailing list