Hello darkness, my old friend.
psycopg2.errors.DeadlockDetected: deadlock detected
DETAIL: Process 8469 waits for ShareLock on transaction 36805309; blocked by process 8483.
Process 8483 waits for ShareLock on transaction 36805301; blocked by process 8469.
Conversation
Protip:
Order the rows you are bulk inserting by the primary key to avoid this. Something I neglected to do this time.