R: R: How to close idle connections

2008-04-28 Thread Enrico Sasdelli
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 overhe

R: R: How to close idle connections

2008-04-28 Thread Enrico Sasdelli
Christopher Schultz wrote: >| Enrico Sadelli wrote: >| If so, I will set maxIdle="2" and everyone will be happy (especially me :) > >That's it! But I suspect that this setting will reduce your performance, >especially if you have an application with lots of db access and >sporadic traffic patterns.