On Fri, 29 May 2009, Fabrix wrote:
In this application is not closing the connection, the development team is makeing the change for close the connection after getting the job done. So most connections are in idle state. How much would this help? Does this could be the real problem?
Ah, now you're getting somewhere. This is actually another subtle problem with making max_connections really high. It lets developers get away with being sloppy in ways that waste large amount of server resources.
Fix that problem, re-test, and then think about changing other things. There's no need to go through kernel changes and the lot if you can nail the problem at its true source and get acceptable performance.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
