[pgpool-general: 3807] Re: Max Connections

[Robert Kennedy]

Hi Tatsuo

I find it unusual that I see 45 of those connections rather than 3. Hence I believe I'm  miss understanding the meaning of each of those settings.

I've attached pgpool.conf version currently is 3.4

I will be upgrading to the latest version later this week.

We using php with and ADODB connection to pgpool, it can pool, what effect would that have?

Thanks


Robert Kennedy| Software & Systems Developer|   
 
Tel: (011) 557-5700  | Ext: 011 557 5729    | Cell: 084 998 9850 
 
 Email : robert at uwiniwin.co.za | Site: www.uwiniwin.co.za 
Address : The Oval Office Park , Ground Floor Kingsmead, Meadowbrook Lane, Bryanston
-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at postgresql.org] 
Sent: Sunday, June 14, 2015 5:02 AM
To: Robert Kennedy
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 3799] Max Connections

> Hi Guys
> 
> I'm struggling to get my max connection correct at the moment.
> 
>>From my understanding,
> 
> num_init_children = 500
> max_pool = 3
> 
> would result in a max of 1500 connections. Based on the combination of 
> username and database. However on the postgres server I see 45 of the 
> following in ps
> 
> postgres 29717  0.0  0.2 1320792 11468 ?       Ss   10:44   0:00 postgres: DB1 DB1 X.X.X.X(34529) idle

Why do you think this is unusual? This just indicates that pgpool-II assign a connection pooling for this PostgreSQL process.

> Eventually I get very strange behave from my webservers as they seem to get 0 result from there queries. This is causing havoc at the moment.

May be your application framework has its own connection pooling?

Anyway can you please provide more info pgpool-II version　pgpool.conf?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 34478 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150615/05c4fd31/attachment-0001.obj>