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

[Tatsuo Ishii]

>> 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...

One possible explanation is, 192.168.9.132 does not have enough
CPU/memory resource to handle 2048 process (1024 pgpool-II + 1024
PostgreSQL). For example 2048 process will produce significant context
switches which in turn gives high CPU load. Can you add more resource
to the server?

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