Re: [psycopg] speed concerns with executemany()

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