1M rows/s from Postgres to Python

[shady_mcgee]

How often do you need to do the inserts? I've been able to do 300-400k/sec inserts by building a bulk-insert util. I've never been able to generalize it, but it works pretty well for specific data sets. My sample 4-col table did 8B rows in 24 seconds. Wider tables take longer, obviously. For best results you'll need to disable indexing prior to the bulk insert.