[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