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

Bo Peng pengbo at sraoss.co.jp
Mon Mar 14 09:31:49 JST 2022


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.


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

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list