Re: [Pgpool-general] query regarding connection pooling

2011-01-12 Thread Sandeep Thakkar
Yes, that is true. I agree. Thanks Tatsuo. From: Tatsuo Ishii To: sandee...@yahoo.com Cc: pgpool-general@pgfoundry.org Sent: Wed, January 12, 2011 2:00:11 PM Subject: Re: [Pgpool-general] query regarding connection pooling > That means, even if the f

Re: [Pgpool-general] query regarding connection pooling

2011-01-12 Thread Sandeep Thakkar
From: Tatsuo Ishii To: sandee...@yahoo.com Cc: pgpool-general@pgfoundry.org Sent: Wed, January 12, 2011 2:00:11 PM Subject: Re: [Pgpool-general] query regarding connection pooling > That means, even if the free connection is available in the pool, pgp

Re: [Pgpool-general] query regarding connection pooling

2011-01-12 Thread Tatsuo Ishii
> That means, even if the free connection is available in the pool, pgpool > starts > a new connection. I think, in terms of connection pooling, pgbouncer looks > better than pgpool. Because, pgbouncer will always first check in the pool > for > the connection and if found, will reuse it. Yes

Re: [Pgpool-general] query regarding connection pooling

2011-01-11 Thread Sandeep Thakkar
. From: Tatsuo Ishii To: sandee...@yahoo.com Cc: pgpool-general@pgfoundry.org Sent: Tue, January 11, 2011 2:59:49 PM Subject: Re: [Pgpool-general] query regarding connection pooling > Hi, > > I'm using "pgpool II 3.0.1" against PPAS8.4 an

Re: [Pgpool-general] query regarding connection pooling

2011-01-11 Thread Tatsuo Ishii
> Hi, > > I'm using "pgpool II 3.0.1" against PPAS8.4 and testing the connection > pooling > feature. > > Here is my settings in pgpool.conf related to this feature: > num_init_children = 3 > max_pool = 1 > child_life_time = 0 > child_max_connections = 0 > client_idle_limit = 0 > > Here is wha

[Pgpool-general] query regarding connection pooling

2011-01-11 Thread Sandeep Thakkar
Hi, I'm using "pgpool II 3.0.1" against PPAS8.4 and testing the connection pooling feature. Here is my settings in pgpool.conf related to this feature: num_init_children = 3 max_pool = 1 child_life_time = 0 child_max_connections = 0 client_idle_limit = 0 Here is what I did: 1. edb-psql -U enter