Search Postgresql Archives

Replication conflicts despite hot_standby_feedback = on?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux