[pgpool-general: 3803] Re: Max Connections

[Tatsuo Ishii]

> 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