Re: Can you please suggest how to configure hot_standby_feedback? - Mailing list pgsql-general

If I have 3 read replicas that all have this set to ON, and someone runs a very long query on one of the replicas, can all three replicas fall behind until the query is finished? This is the behavior I observed more than once, but I can’t seem to be able to explain it based on the documented behavior of this parameter. 

A related question is — how can you avoid doing auto vacuum during the busy peak hours, and do more aggressive auto vacuuming at night during low traffic? Is that possible?

I tried achieving that with a manual vacuum, but that causes all replicas to get far behind while it’s running, which is also not acceptable.

Thanks so much!