title: PostgreSQL Autocommit efficiency on SELECT queries
body: <p>I am using Psycopg2 to issue many <code>SELECT</code> queries to my Postgres DB. These queries have a small size result and they are sent at a high frequency.</p>
  
  <p>In order to avoid managing transactions myself (because I'm lazy), I have set <code>autocommit = True</code> in the session settings.</p>
  
  <p>Edit: there is no long pause between queries, no data manipulation, and the cursor gets closed immediately after I stop making queries.</p>
  
  <p>I would like to know: When issuing <code>SELECT</code> queries at a high frequency, is there any performance penalty of using autocommit?</p>
  
  <p>Using Postgres 9.6 and Psycopg 2.7.7. And <em>yes</em>, I am using prepared statements.</p>