[postgis-devel] shp2pgsql multi-transaction INSERT mode
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.
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-devel