<div dir="ltr"><div dir="ltr"><div>I use pgpool with 5 slave on mode synchronous.</div><div>But sometimes i see values on column replication_delay when execute command show pool_nodes.</div><div>Sometimes, when a node goes beyond the value of delay_threshold, the node does not receive balancing query.</div><div><br></div><div>But</div><div>1- Synchronous replication should not be delayed is not it?</div><div>2- How is this possible ?</div><div>3- Is the replication_delay parameter of pgpool wrong?</div><div><br></div><div>show pool_nodes</div><div> node_id |  hostname   | port | status | lb_weight |  role   | select_cnt | load_balance_node | replication_delay | last_status_change  </div><div>---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------</div><div> 0       | IP          | 5432 | up     | 0.100000  | primary | 230616548  | false             | 0                 | 2019-10-24 19:17:27</div><div> 1       | IP          | 5432 | up     | 0.100000  | standby | 172466610  | true              | 0                 | 2019-10-24 19:17:27</div><div> 2       | IP          | 5432 | up     | 0.100000  | standby | 180179200  | false             | 234324            | 2019-10-24 19:17:27</div><div> 3       | IP          | 5432 | up     | 0.100000  | standby | 178475037  | false             | 20777216          | 2019-10-24 19:17:27</div><div> 4       | IP          | 5432 | up     | 0.100000  | standby | 182174042  | false             | 0                 | 2019-10-24 19:17:27</div><div> 5       | IP          | 5432 | up     | 0.100000  | standby | 181169375  | false             | 0                 | 2019-10-24 19:17:27</div><div><br></div><div><br></div><div><br></div><div>pg_stat_replication</div><div>  application_name  | client_addr |  write_lsn   |  flush_lsn   |    write_lag    | sync_priority | sync_state </div><div>--------------------+-------------+--------------+--------------+-----------------+---------------+------------</div><div> pje1_slave1        | IP          | 8FA/42E88B60 | 8FA/42E88B60 | 00:00:00.000355 |             1 | sync</div><div> pje1_slave2        | IP          | 8FA/42E88B60 | 8FA/42E88B60 | 00:00:00.000312 |             2 | potential</div><div> pje1_slave3        | IP          | 8FA/42E88B60 | 8FA/42E88B60 | 00:00:00.000366 |             3 | potential</div><div> pje1_slave4        | IP          | 8FA/42E88B60 | 8FA/42E88B60 | 00:00:00.000277 |             4 | potential</div><div> pje1_slave5        | IP          | 8FA/42E88B60 | 8FA/42E88B60 | 00:00:00.000265 |             5 | potential</div><div><br></div>-- <br><div dir="ltr" class="gmail_signature">foobar</div></div></div>