psycopg2 -向多个表中插入行的最快方法？

import psycopg2

# 连接到PostgreSQL数据库
conn = psycopg2.connect(database="your_database", user="your_user", password="your_password", host="your_host", port="your_port")

# 创建一个游标对象
cur = conn.cursor()

try:
    # 开始事务
    conn.autocommit = False

    # 执行插入操作
    cur.execute("INSERT INTO table1 (column1, column2) VALUES (%s, %s)", (value1, value2))
    cur.execute("INSERT INTO table2 (column1, column2) VALUES (%s, %s)", (value3, value4))

    # 提交事务
    conn.commit()

except psycopg2.DatabaseError as e:
    # 发生错误时回滚事务
    conn.rollback()
    print('Error: %s' % e)

finally:
    # 关闭游标和数据库连接
    cur.close()
    conn.close()