On 12/23/2016 05:37 PM, Christophe Pettus wrote:
>
>> On Dec 23, 2016, at 17:23, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>> Yet the data was available immediately in another session without a explicit COMMIT, so how is psycopg2 committing
theINSERTs?
>
> autocommit = True means psycopg2 doesn't issue an initial BEGIN, so each INSERT commits when done (just like a
top-levelpsql session)... thus "autocommit."
Alright that I get. Still the practical outcome is each INSERT is being
done in a transaction (an implicit one) so the transaction overhead
comes into play. Or am I missing something?
>
> --
> -- Christophe Pettus
> xof@thebuild.com
>
--
Adrian Klaver
adrian.klaver@aklaver.com