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

Tatsuo Ishii ishii at postgresql.org
Mon Aug 10 14:10:26 JST 2015


> pgpool :   192.168.9.132 (master), 192.168.9.133(slaver)
> postgresql: 192.168.9.132 (slaver),  192.168.9.133(master)
> pgbench   192.168.9.203
> 
> 
> 
> 
> When i test with postgresql, it cost a little time ( 5 seconds) to establish new connection.

I assume you run pgbench on 192.168.9.203.

So one PostgreSQL server spends 5 seconds for opening 1024
connections. Because you have two PostgreSQL servers spending 10
seconds to open 1024 connections to both PostgreSQL. But still extra
10 seconds does not explain. Let me think it about...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list