python+psycopg2+postgresql 一次大数据

暂且把解决过程记录一下，还没有整理……

insert on conflict - 合并写 （消除不必要更新）
https://yq.aliyun.com/articles/590326
PostgreSQL记录不存在则插入，存在则更新的做法
https://my.oschina.net/u/3400816/blog/1930307

conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)

ON_ERROR_ROLLBACK
[https://blog.csdn.net/sinat_29742125/article/details/75356295]
[https://community.pivotal.io/s/article/How-to-Overcome-the-Error-current-transaction-is-aborted-commands-ignored-until-end-of-transaction-block]

数据库：事务
https://blog.csdn.net/dilixinxixitong2009/article/details/80256732

Psycopg2 error messages
https://stackoverflow.com/questions/6697719/psycopg2-error-messages
http://initd.org/psycopg/docs/errors.html

相似问题
[https://stackoverflow.com/questions/27113250/postgresql-equivalent-of-mysql-force-flag]
[https://blog.csdn.net/hantiannan/article/details/4590259]