-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 David,
David Smith wrote: | I'll bet money the added, idle postgres connections are just sleeping | while they wait for work. Given idle connections contribute virtually | no additional load, don't see his argument that idle connections | contribute to a database overload. If the minor increase in overhead | due to sleeping threads actually overloads the database, you need to let | your boss know the server hardware is way too frail for production use | and needs to be upgraded. It could be a memory issue, and perhaps with lots of connections from different machines (maybe a clustered application and a single database instance)... lots of connections == lots of memory allocated on the server, even when the connections are idle. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkgWGZcACgkQ9CaO5/Lv0PCVVgCgiQHs4I8xJfbupkGXUHEBLgci qmQAn3yNwIsnO4jzF/GobTZyzXp8fe17 =ma/c -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]