with cursor.copy("COPY weather FROM STDIN (FORMAT BINARY)") as copy: for row in large_dataset: copy.write_row(row) | Driver | Time (ms) | CPU Usage | Memory | |--------|-----------|-----------|--------| | psycopg2 (sync) | 890 | 18% | 32 MB | | psycopg3 (async) | 720 | 15% | 28 MB | | pgx (Go) | 410 | 12% | 18 MB | | node-postgres | 950 | 22% | 48 MB |
async with await pool.cursor() as cur: await cur.execute("SELECT * FROM users WHERE id = %s", (user_id,)) This sends Parse, Bind, Execute messages, reusing the plan on subsequent calls. For bulk inserts, drivers support binary COPY protocol, which is 5–10x faster than batched INSERTs: driver postgresql