Re: [PERFORM] Large number of short lived connections - could a connection pool help?

2011-11-15 Thread Mario Weilguni
Am 15.11.2011 01:42, schrieb Cody Caughlan: We have anywhere from 60-80 background worker processes connecting to Postgres, performing a short task and then disconnecting. The lifetime of these tasks averages 1-3 seconds. I know that there is some connection overhead to Postgres, but I dont

[PERFORM] Large number of short lived connections - could a connection pool help?

2011-11-14 Thread Cody Caughlan
We have anywhere from 60-80 background worker processes connecting to Postgres, performing a short task and then disconnecting. The lifetime of these tasks averages 1-3 seconds. I know that there is some connection overhead to Postgres, but I dont know what would be the best way to measure this

Re: [PERFORM] Large number of short lived connections - could a connection pool help?

2011-11-14 Thread Cody Caughlan
On Mon, Nov 14, 2011 at 4:59 PM, Ben Chobot be...@silentmedia.com wrote: On Nov 14, 2011, at 4:42 PM, Cody Caughlan wrote: We have anywhere from 60-80 background worker processes connecting to Postgres, performing a short task and then disconnecting. The lifetime of these tasks averages 1-3

Re: [PERFORM] Large number of short lived connections - could a connection pool help?

2011-11-14 Thread Ben Chobot
On Nov 14, 2011, at 4:42 PM, Cody Caughlan wrote: We have anywhere from 60-80 background worker processes connecting to Postgres, performing a short task and then disconnecting. The lifetime of these tasks averages 1-3 seconds. [snip] Is this something that I should look into or is it not