[Postgres-xc-general] what is the performance drop because of the synchronous GTM status backup to GTM-standby

[Prasad V. <va...@gm...>]

Hi,

1) I am trying to evaluate the High Availability aspects of PGXC; and
notice that GTM, and GTM-standby are configured to be in continuous
sync. That means, every status change in GTM is synchronously made at
GTM-standby.  In such setup, what is the performance drop becoz of
gtm-standby.

Are there any benchmark tests run with and without GTM-standby?? what
are the numbers??

2) How is GTM failure discovered? Vanilla PGXC, doesn't integrate with
clusters like Corosync, right??

3) During GTM-failover, I see bunch of manual steps are needed to
promote the GTM-standby to master; and make the GTM-proxies reconnect
to the new GTM. What happens to the in-flight and new transactions
while this GTM-failover happening??
I guess all active transaction will have to hang during this period, isn't??

thanks,
-Prasad