Postgres Pro
Downloads
Home   >   mailing lists

hot_standby_feedback parameter doesn't work - Mailing list pgsql-admin

From Andrey Zhidenkov
Subject hot_standby_feedback parameter doesn't work
Date
Msg-id CAJw4d1Vnw+BFVuSnSne8APg+e1cD0p4RVOtdqpf3pEVaSgb3Cw@mail.gmail.com
Whole thread Raw
Responses Re: hot_standby_feedback parameter doesn't work  (Andres Freund <andres@anarazel.de>)
Re: hot_standby_feedback parameter doesn't work  (Rui DeSousa <rui@crazybean.net>)
Re: hot_standby_feedback parameter doesn't work  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: query can't merge into table of the other schema
Next
From: Nikhil Shetty
Date:
Subject: Re: How to downgrade a cluster from 9.5 to 9.3