On Tue, Dec 6, 2011 at 1:19 PM, Euler Taveira de Oliveira
> A while ago when blogging about WAL , I noticed a function to deal with
> xlog location arithmetic is wanted. I remembered Depez  mentioning it and
> after some questions during trainings and conferences I decided to translate
> my shell script function in C.
> The attached patch implements the function pg_xlog_location_diff (bikeshed
> colors are welcome). It calculates the difference between two given
> transaction log locations. Now that we have pg_stat_replication view, it will
> be easy to get the lag just passing columns as parameters. Also, the
> monitoring tools could take advantage of it instead of relying on a fragile
> routine to get the lag.
> I noticed that pg_xlogfile_name* functions does not sanity check the xrecoff
> boundaries but that is material for another patch.
>  http://eulerto.blogspot.com/2011/11/understanding-wal-nomenclature.html
I think that this function is very useful. Can you add the patch into
CommitFest 2012-1 ?
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Euler Taveira de Oliveira||Date: 2012-01-14 14:12:21|
|Subject: Re: xlog location arithmetic|
|Previous:||From: Thomas Munro||Date: 2012-01-14 13:42:01|
|Subject: Re: Multithread Query Planner|