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

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

>> pgpool : (master),
>> postgresql: (slaver),
>> pgbench
>> When i test with postgresql, it cost a little time ( 5 seconds) to establish new connection.
> I assume you run pgbench on
> 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, 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

More information about the pgpool-general mailing list