Articles tagged "bulk-insert"

Python sqlalchemy postgresql performance database
15 min readIntermediate

SQLAlchemy Bulk Insert: Fastest Methods Benchmarked — Core insert(), ON CONFLICT, COPY (240x)

Benchmark SQLAlchemy bulk insert: execute(insert()), bulk_save_objects, ON CONFLICT upserts, PostgreSQL COPY via psycopg2 — 240x faster than add_all().