Re: [ADMIN] High replication lag - Stream Replication

On Wed, Nov 8, 2017 at 6:38 AM, Marcelo Kruger
<marcelo(dot)kruger(at)neoway(dot)com(dot)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 database is slow, always generating replication lag.
>
> The replication lag increases considerably when queries are performed on the StandBy database. I wonder if there is any setting 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.