Christopher Schultz wrote:
-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
-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
On Apr 28, 2008, at 9:59 AM, Alan Chaney wrote:
David Smith wrote:
No, I have at most 20 idle connections, that's goes right, but my
boss want
less idle connections to avoid to overload the database server. So
there
isn't way to close an idle connection to remove the relative
process
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
On 28/04/2008, at 4:59 PM, Alan Chaney wrote:
David Smith wrote:
No, I have at most 20 idle connections, that's goes right, but my
boss want
less idle connections to avoid to overload the database server. So
there
isn't way to close an idle connection to remove the relative
process?
If
David Smith wrote:
No, I have at most 20 idle connections, that's goes right, but my boss
want
less idle connections to avoid to overload the database server. So there
isn't way to close an idle connection to remove the relative process?
If so, I will set maxIdle="2" and everyone will be ha
No, I have at most 20 idle connections, that's goes right, but my boss want
less idle connections to avoid to overload the database server. So there
isn't way to close an idle connection to remove the relative process?
If so, I will set maxIdle="2" and everyone will be happy (expecially me :)
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.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Enrico,
Enrico Sasdelli wrote:
| No, I have at most 20 idle connections, that's goes right, but my boss
want
| [fewer] idle connections to avoid to overload the database server. So
there
| isn't way to close an idle connection to remove the relative
Thanks for reply,
>I see you have maxIdle="20". Do you have more that 20 connections
>sitting idle? Is this really that much of a concern? As long as the
>connections are released (closed) and returned to the pool, I don't see
>the problem.
No, I have at most 20 idle connections, that's go
10 matches
Mail list logo
