Finding slave WAL application time delay

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Finding slave WAL application time delay
Date: 2010-07-20 19:13:45
Message-ID: 201007201913.o6KJDjK05386@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Because an idle master will not generate WAL, I don't think there is a
way to report the time delay in receiving WAL.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ None of us is going to be here forever. +

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Wanner 2010-07-20 19:14:23 Re: dynamically allocating chunks from shared memory
Previous Message Peter Eisentraut 2010-07-20 19:12:29 Re: antisocial things you can do in git (but not CVS)