pg_stat_replication view

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: pg_stat_replication view
Date: 2018-12-10 19:24:43
Message-ID: CAMkU=1wVVWFy=7y+gsydrc6SW0rQMwoaopw8HGwfOHYYJG59fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm not sure if this is a documentation issue, or something else.

The description of the pg_stat_replication.state column gives:

* catchup: This WAL sender's connected standby is catching up with the
primary.

* streaming: This WAL sender is streaming changes after its connected
standby server has caught up with the primary.

What does this mean? Is the standby "caught up" when it replays the LSN
which was current on the master as-of the time that the standby initiated
this connection? Or is it caught up when the master receives at least one
notification that a certain LSN was replayed on the replica, and verifies
that no new WAL has been generated after that certain LSN was generated?
Neither of those things?

If a replica has caught up and then fallen behind again, is that different
from a user/dba perspective than if it never caught up in the first place?

Also, the docs say "Lag times work automatically for physical replication.
Logical decoding plugins may optionally emit tracking messages; if they do
not, the tracking mechanism will simply display NULL lag." Does the
logical decoding plugin associated with built-in PUBLICATION/SUBSCRIPTION
mechanism introduced in v10 emit tracking messages?

Cheers,

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Carroll 2018-12-10 19:26:36 Memory exhaustion due to temporary tables?
Previous Message Kevin Brannen 2018-12-10 17:58:34 RE: syntax error with alter type