[pgpool-general: 7630] Re: Pgpool replication delay

Tatsuo Ishii ishii at sraoss.co.jp
Fri Jul 2 21:34:32 JST 2021


> Hi,
> 
> While load testing with concurrent users, we noticed that some read
> operations reported the record not existing.
> The load test creates and reads records.
> When we manually query after load test, the record is in both master and
> standby DBs.
> Is it because of the replication delay and the read from standby fails?

Yes.

> Any recommendations for this kind of scenario?

synchronous_commit = remote_apply will help at the expense of
performance.

Best regards,
--
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