擅长:python、mysql、java
<p>Psycopg2需要在每个事务(包括SELECT查询)之后进行提交或回滚,否则会使连接“在事务中处于空闲状态”。以下是文档中的警告:</p>
<blockquote>Warning: By default, any query execution, including a simple SELECT will start a transaction: for long-running programs, if no further action is taken, the session will remain “idle in transaction”, an undesirable condition for several reasons (locks are held by the session, tables bloat...). For long lived scripts, either ensure to terminate a transaction as soon as possible or use an autocommit connection.</blockquote>