<a href= 'http://students.mimuw.edu.pl/~jd334392/project/psycopg2-2.5.2/doc/html/pool.html'>官方文档 点这里</a>
这里对普通的connection和使用pool的connection进行了10000次查询测试
普通的代码：
import psycopg2
from time import time
t = time()
n = 10000
while n:
n -= 1
conn = psycopg2.connect(dbname = 'enterprise-test', user = 'lovedrose', password = '', host = '127.0.0.1')
cur = conn.cursor()
cur.execute('select * from cmps_key_value')
cur.fetchall()
print(time() - t)
消耗：52.5323209763
使用了连接池的代码
import psycopg2.pool
from time import time
t = time()
n = 10000
lst = [str(i) for i in range(20)]
simple_conn_pool = psycopg2.pool.SimpleConnectionPool(5, 200, host = '127.0.0.1',user = 'lovedrose', password = '', dbname = 'enterprise-test')
while n:
key = lst.pop(0)
conn = simple_conn_pool.getconn(key)
cur = conn.cursor()
cur.execute('select * from cmps_key_value')
cur.fetchall()
n -= 1
lst.append(key)
print(time() - t)
simple_conn_pool.closeall()
消耗：4.29549717903
快了近12倍
