On Sat, Dec 24, 2016 at 1:09 AM, Christophe Pettus <xof(at)thebuild(dot)com> wrote:
> Are you running with the transaction isolation level set to ISOLATION_LEVEL_AUTOCOMMIT? If so, each of those INSERTs will be in its own transaction, and thus will go through the COMMIT overhead. That by itself wouldn't explain a jump that large (in most environments), but it will definitely be *much* slower.
Why do you say this? Psycopg doesn't wrap statements in BEGIN/COMMIT
when in autocommit mode. Are you referring about some implicit
transaction created by the database?
-- Daniele