[postgis-devel] shp2pgsql multi-transaction INSERT mode

[Rémi Cura]

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?
Cheers,
Rémi-C


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>