On 2020-Jan-29, Kyotaro Horiguchi wrote:
> But as more significant issue, nowadays PostgreSQL doesn't run a
> checkpoint if it is really inactive (that is, if no "important" WAL
> records have issued.).
Yeah, I mentioned this in message
<20200127203419.GA15216@alvherre.pgsql>. The solution for monitoring
purposes is to use the new "lag" columns in pg_stat_replication. But
that's not available in older releases (prior to 10), so this change is
still useful.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services