[postgis-devel] [postgis-users] Changing transaction behaviour in shp2pgsql
Chris Hodgson
chodgson at refractions.net
Sun Mar 14 15:41:25 PDT 2010
It's chunked because loading records individually is significantly
slower, and doing one large transaction can easily run you out of
memory/transaction space.
Chris
strk wrote:
> On Sun, Mar 14, 2010 at 04:58:02PM +0700, Ben Madin wrote:
>
>
>> in the event I can't work out the encoding, is there any way to turn off the transaction behaviour, ie I'm happy to miss 4 records, but not 1000 as a result of the transactions being aborted. (short of putting it all into a text file and removing all the begin and commit commands...)
>>
>
> Feel like working on a patch to make "transaction policy" selectable
> with a switch ?
>
> -T <policy> transaction policy (single*,none)
>
> Current policy is chunked, dunno for what rationale..
>
> --strk;
>
> () Free GIS & Flash consultant/developer
> /\ http://strk.keybit.net/services.html
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
More information about the postgis-devel
mailing list