Re: [PERFORM] limit connections pgpool

2013-10-10 Thread Tatsuo Ishii
> Hi, i want to know what is the pgpool parameter for close the > connections directly in the database, because the pgpool II close fine > the the childs with the life time, but the connection in the database > continue open in idle state. That's the result of connection cache functionality of pgp

Re: [PERFORM] limit connections pgpool

2013-10-10 Thread Michael Paquier
On Fri, Oct 11, 2013 at 12:00 AM, Jeison Bedoya Delgado wrote: > Hi, i want to know what is the pgpool parameter for close the connections > directly in the database, because the pgpool II close fine the the childs > with the life time, but the connection in the database continue open in idle > st

[PERFORM] Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?

2013-10-10 Thread Merlin Moncure
On Mon, Oct 7, 2013 at 10:35 PM, Kevin Grittner wrote: > Aftab Ahmed Chandio wrote: > >> My query processes from JDBC (Java Program) to PostgreSQL. I use >> system time by invoking java function, I collect one time unit >> before the query statement perform and second after the execution >> of qu

[PERFORM] limit connections pgpool

2013-10-10 Thread Jeison Bedoya Delgado
Hi, i want to know what is the pgpool parameter for close the connections directly in the database, because the pgpool II close fine the the childs with the life time, but the connection in the database continue open in idle state. this is my pool config num_init_children = 100 max_pool = 8 c