=?UTF-8?B?VG9yc3RlbiBGw7ZydHNjaA==?= <torsten.foertsch@xxxxxxx> writes: > The replicas are far away, intercontinental far. I am not complaining > that the replica looses the connection. What makes me wonder is that > within a transaction, pg_stat_replication can forget rows but cannot > acquire new ones. I'd think it should be either report the state at the > beginning of the transaction like now() or the current state like > clock_timestamp(). But currently it's reporting half the current state. Are you watching the state in a loop inside a single plpgsql function? If so, I wonder whether the problem is that the plpgsql function's snapshot isn't changing. From memory, marking the function VOLATILE would help if that's the issue. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
