[pgpool-general: 8049] Re: delay_threshold redirect to replicas

[Bo Peng]

Hello,

On Sun, 13 Mar 2022 14:42:59 -0400
Franklin Anderson de Oliveira Souza <franklinbr at gmail.com> wrote:

> hello dear,
> 
> is it possible to redirect queries to other replicas instead of the master
> when the delay_threshold limit is exceeded!?  the default is to redirect to
> master.

If you are uing Pgpool-II 4.3.x, you can enable "prefer_lower_delay_standby" parametr
to route the queries to the standby with the least delay.

https://www.pgpool.net/docs/latest/en/html/runtime-streaming-replication-check.html#GUC-PREFER-LOWER-DELAY-STANDBY

> Tanks !
> -- 
> Enviado do Gmail para celular


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/