Psycopg2在大型选择查询上用尽了内存

您可以使用服务器端游标。

cur = conn.cursor('cursor-name') # server side cursorcur.itersize = 10000 # how much records to buffer on a clientcur.execute("SELECt * FROM mytable;")