[pgpool-general: 3803] Re: Max Connections

Tatsuo Ishii ishii at postgresql.org
Sun Jun 14 12:01:30 JST 2015

> 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

More information about the pgpool-general mailing list