[pgpool-general: 8750] Re: setting "delay_threshold_by_time" to less than 1 second

[zam bak]

On Mon, May 1, 2023 at 4:49 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> Hello,
>
> > Is it possible to set "delay_threshold_by_time" to an interval less
> > than 1 second?
> > For example, 250 ms
> > delay_threshold_by_time=0.25
>
> No. You can only set this parameter in seconds.
>

Thanks for confirmation.
Is it possible to request an improvement so that values less than 1
second can be specified and used?



> On Mon, 24 Apr 2023 10:03:18 -0400
> zam bak <zam6ak at gmail.com> wrote:
>
> > Hi
> >
> > Is it possible to set "delay_threshold_by_time" to an interval less
> > than 1 second?
> > For example, 250 ms
> > delay_threshold_by_time=0.25
> >
> > When I tried this, I noticed that no logging occurs when the threshold
> > is exceeded (I use "log_standby_delay = 'if_over_treshold'") and "SHOW
> > POOL_NODES" always shows the "replication_delay" column as 0.
> >
> > When I set it to "1" logging works as well as "SHOW POOL_NODES"
> >
> >
> > Regards
> > Z..
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS LLC
> https://www.sraoss.co.jp/