ncalls  tottime  percall  cumtime  percall filename:lineno(function)\n       37    0.723    0.020    0.723    0.020 storemysql.py:139(_get_conn)\n       37    0.029    0.001    0.029    0.001 storesqlite.py:69(_get_conn)\n\nversus\n\n       37    3.525    0.095    3.525    0.095 storepypgsql.py:55(_get_conn)\n       37    5.524    0.149    5.524    0.149 storepypgsql.py:55(_get_conn)

Wow. I guess libpq on Windows has some serious drawbacks, taking 4 to 8 times as long as MySQL to open a connection, on average.

But it does so optimistically:

1. If there's an (already open) connection in the pool, it gets popped and used.
2. If there isn't a conn ready right away, a new conn is made.
3. When the thread is finished with the conn, it tries to push it into the pool.
4. If the pool is full (mine was max 10), the free conn is closed and discarded.

The 37 connections are far less than the total number of statements. ;) This is *testing* code, ma man.