From: | Bill Brown <billb(at)consistentstate(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql BDR(Bi-Directional Replication) Latency Monitoring |
Date: | 2015-03-16 18:27:39 |
Message-ID: | CAPzMWFyNkgOkY7=-oT1gngN0c-=R64hfXKHFMOE0+AeF6023Ng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I'm looking at BDR monitoring documentation at this location
https://wiki.postgresql.org/wiki/BDR_Monitoring
I understand the query in documentation:
select slot_name, plugin, database, active, xmin,
pg_get_transaction_committime(xmin)
FROM pg_stat_logical_decoding ;
Should be:
select slot_name, plugin, database, active, xmin,
pg_get_transaction_committime(xmin)
FROM pg_replication_slots ;
I am running PostgreSQL 9.4.0 bits on Centos:
postgresql-bdr94-contrib-9.4.0_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-libs-9.4.0_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-bdr-0.8.0beta1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-2ndquadrant-redhat-1.0-2.noarch
postgresql-bdr94-devel-9.4.0_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-server-9.4.0_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-9.4.0_bdr1-1_2ndQuadrant.el6.x86_64
We have 3 nodes set-up. We would like to understand the latency between
nodes.
When using http://oltpbenchmark.com/ to create a load on one node, I would
expect the 'xmin' value not to be null but is.
What is the best way to monitor replication latency when using Postgresql
BDR?
Regards,
Bill
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Watson | 2015-03-16 18:50:05 | Slow query with join |
Previous Message | Luca Ferrari | 2015-03-16 17:23:37 | Re: psql sqlstate return code access |