[pgpool-general: 8735] Re: Clients disconnection when slave node is off

Tatsuo Ishii ishii at sraoss.co.jp
Wed Apr 12 10:33:51 JST 2023


> However a downside of this is, while failover clients cannot process
> queries or at least slow down processing. Below is the log from
> pgbench using "-P 1" option to show progress. As you can see from 170
> s pgbench starts to slow down and recovers at 194 s. That is, the
> slowdown continued for 24 seconds.
> 

After more research, I suspect the slow down is due to effect of
checkpointing. If I add "-S" option to change the transaction time, I
don't see the slow down anymore.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp



More information about the pgpool-general mailing list