On Wed, Jul 11, 2012 at 5:47 PM, Yan Chunlu <springrider@xxxxxxxxx> wrote: > I learnt a lot during the back and forth! Great to hear. >> 1, postgresql always have 400+ connections(dozens of python process using client pool) Note that Postgres does not deal well with a large number of connections[1]: consider shrinking the size of the pool. [1]: http://wiki.postgresql.org/wiki/Number_Of_Database_Connections -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
