Postgres Pro
Downloads
Home   >   mailing lists

Re: [psycopg] speed concerns with executemany() - Mailing list psycopg

From Christophe Pettus
Subject Re: [psycopg] speed concerns with executemany()
Date
Msg-id EB1F8C89-4106-43BB-AB42-A6665F22B07D@thebuild.com
Whole thread Raw
In response to Re: [psycopg] speed concerns with executemany()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [psycopg] speed concerns with executemany()  (Adrian Klaver <adrian.klaver@aklaver.com>)
List psycopg
Tree view 
> 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." 

--
-- Christophe Pettus
   xof@thebuild.com

psycopg by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [psycopg] speed concerns with executemany()
Next
From: Adrian Klaver
Date:
Subject: Re: [psycopg] speed concerns with executemany()