Re: [ADMIN] High replication lag - Stream Replication

On Wed, Nov 8, 2017 at 6:38 AM, Marcelo Kruger
<marcelo.kruger@neoway.com.br> wrote:

> Good afternoon,
>
> I have two servers hosted on Azure with PostgreSQL 9.6 databases. One database is production, the other is standby.
> For replication I use stream replication between servers. However the application of the archives in the standby
databaseis slow, always generating replication lag.
 
>
> The replication lag increases considerably when queries are performed on the StandBy database. I wonder if there is
anysetting that can be made to improve this performance.
 

SNIP

> Configuration PostgreSQL StandBy
>
> postgres.conf

SNIP

> hot_standby = on
> hot_standby_feedback = on

I've recently run into the same thing and it's a result of long
running queries on the standby. Moving those queries to the master and
/ or fixing them to not run so long fixed out problem.