cursor.executemany generates multiple INSERTs

From: Idan Kamara <idankk86(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: cursor.executemany generates multiple INSERTs
Date: 2012-11-26 10:53:07
Message-ID: CAMz0A7kFM+v5P7acsjGUa0odqj8heLvpe=vLU9ZDARu4Aivo8Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi,

When using executemany to do a bulk insert, psycopg2 generates an
INSERT for each item in the given sequence of items.

This is a lot slower than a single INSERT using Postgres multirow
VALUES syntax, e.g.

INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');

Why doesn't psycopg2 use this syntax?

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2012-11-26 11:51:39 Re: cursor.executemany generates multiple INSERTs
Previous Message Neil Tiffin 2012-11-20 21:27:44 Re: Trying to understand why same SQL returns different results.