hot_standby_feedback parameter doesn't work

From: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: hot_standby_feedback parameter doesn't work
Date: 2018-11-13 03:28:20
Message-ID: CAJw4d1Vnw+BFVuSnSne8APg+e1cD0p4RVOtdqpf3pEVaSgb3Cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have a few database clusters (1 master, 2 hot standbys) with
hot_standby_feedback setting on. But I am constantly seeing query
conflicts on standbys because dead rows on the masters are deleted by
VACUUM. Usually I notice it shortly after VACUUM ends, because the
replication lag on replicas is starting to increase.

vacuum_defer_cleanup_age = 0. PostgreSQL version is 9.5.13. Cluster
load is about 1500 transactions per second.

Any ideas?

-
With the best regards, Andrey Zhidenkov

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nikhil Shetty 2018-11-13 04:19:17 Re: How to downgrade a cluster from 9.5 to 9.3
Previous Message Pepe TD Vo 2018-11-12 18:42:00 Re: query can't merge into table of the other schema