[postgis-devel] shp2pgsql multi-transaction INSERT mode

Rémi Cura remi.cura at gmail.com
Fri Jul 18 03:26:07 PDT 2014

You can have this in both scenario,
you can put a transaction on top of everything.
Insert on multiple line is faster, yet copy is even faster.
Does shp2pgsql uses it?

2014-07-18 11:36 GMT+02:00 Mark Cave-Ayland <mark.cave-ayland at ilande.co.uk>:

> On 18/07/14 10:17, Sandro Santilli wrote:
>  It looks like shp2pgsql doesn't do INSERT in multiple
>> transactions anymore, but I couldn't figure out since when.
>> It used to do 250 inserts per transaction around 2004, do
>> you know when was that changed and why ?
> Not sure - check the history? However I would definitely have argued to
> remove this, given as I have personal experience that the time cost of
> manually sorting through a partial committed shapefile is exponentially
> larger than failing individual queued shapefiles so you easily know which
> files you need to retry.
> ATB,
> Mark.
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20140718/daf2b0db/attachment.html>

More information about the postgis-devel mailing list