I'm seeing the following at a customer site:

SELECT confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, 
confl_deadlock
FROM pg_stat_database_conflicts
WHERE datname = 'something' \gx

-[ RECORD 1 ]----+------
confl_tablespace | 0
confl_lock       | 0
confl_snapshot   | 84990
confl_bufferpin  | 0
confl_deadlock   | 0

SHOW hot_standby_feedback;

 hot_standby_feedback 
----------------------
 on
(1 row)

This is PostgreSQL 11.7, the standby didn't disconnect from the primary, and
the number of replication conflicts is growing.

I had thought that "hot_standby_feedback = on" would get rid of such
conflicts.

In the code I see a lot of call sites for ResolveRecoveryConflictWithSnapshot,
so it is hard for me to track this down.  Does anybody know what could cause
these replication conflicts?

Yours,
Laurenz Albe



Reply via email to