擅长:python、mysql、java
<p>我想你在找<a href="http://initd.org/psycopg/docs/extras.html#fast-execution-helpers" rel="nofollow noreferrer">Fast Execution helpers</a>:</p>
<pre><code>mylist=[('t1',), ('t2',)]
execute_values(cursor2, "INSERT INTO sample(domain) %s", mylist, page_size=100)
</code></pre>
<p>它的作用是用100个值替换%s。我不知道你可以设置多高的页面大小,但这应该是更高的性能。在</p>