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.
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
pgsql-hackers by date
|Next:||From: Noah Misch||Date: 2011-12-06 06:16:48|
|Subject: Re: Configuration include directory|
|Previous:||From: Robert Haas||Date: 2011-12-06 03:36:24|