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
