psycopg2处理大数据量SQL在execute(sql)卡死？-灵析社区
Kapp啊$0920用服务器端游标: with conn.cursor(name='server_cursor') as cursor: cursor.itersize = 10000 # 设置你要的批量大小 cursor.execute(sql) for record in cursor: # 处理记录
用服务器端游标: with conn.cursor(name='server_cursor') as cursor: cursor.itersize = 10000 # 设置你要的批量大小 cursor.execute(sql) for record in cursor: # 处理记录