[pgpool-general: 3940] Re: pgpool establish new connection too slow

[Tatsuo Ishii]

> I have test pgpool with pgbench as follows:
> 
> 
> pgbench -l -c 1024 -t 5 -r pgbench -p9999 -h192.168.9.190 -Unopass
> 
> 
> I find pgpool cost a lot of time (20 seconds) to establish 1024 connection.
> 
> 
> 2015-08-10 19:58:20: pid 18756: DETAIL: connecting host=192.168.9.203 port=34465
> 2015-08-10 19:58:21: pid 18206: LOG: new connection received
> 2015-08-10 19:58:21: pid 18206: DETAIL: connecting host=192.168.9.203 port=34466
> 2015-08-10 19:58:21: pid 19039: LOG: new connection received
> 
> 
> How to config pgpool.conf to speed up new connection?

I assume you run pgbench on 192.168.9.203, pgpool-II is running on
192.168.9.190 and PostgreSQL runs somewhere (you didn't mention it).

I recommend you to run pgbench against PostgreSQL and see how long the
connection establish time is:

pgbench -l -c 1024 -t 5 -r pgbench -p9999 -h IP_PostgreSQL_RUNS_ON -Unopass

If it's something like 20 seconds, pgpool-II has not much to do with it
because the overhead comes from PostgreSQL.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp