Finding slave WAL application time delay
in [PgSql]
|
Prev: [HACKERS] Finding slave WAL application time delay
Next: Fwd: [HACKERS] Streaming Replication: Checkpoint_segment and wal_keep_segments on standby
From: Robert Haas on 20 Jul 2010 20:36 On Tue, Jul 20, 2010 at 3:13 PM, Bruce Momjian <bruce(a)momjian.us> wrote: > Someone at OSCON just asked if there is a way to find the _time_ delay > between received and applied WAL. �Right now > pg_last_xlog_replay_location() only reports the information in WAL > scale. �It would be nice to report that in time, e.g. milliseconds. There's probably more than one way you can define this. See, for example, previous discussions of max_standby_delay. > Because an idle master will not generate WAL, I don't think there is a > way to report the time delay in receiving WAL. You could certainly come up with a sensible definition for this, though there are also nonsensical ones. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |