Re: hot_standby_feedback parameter doesn't work

From: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
To: andres(at)anarazel(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: hot_standby_feedback parameter doesn't work
Date: 2018-11-13 07:03:36
Message-ID: CAJw4d1WtzOdYzd8Nq2=uFK+Z0JY0L_pfg9TvCWPrmt3NCZq9GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have increasing replication lag on the hot standby. I grep processes
on the stanby and see that WAL writer is in status "waiting". This
always happens after (auto)vacuuming of table used by problem query.
Once I kill problem query on the standby WAL segments are applied and
the replication lag is no longer exists.

Forgot to mention that max_standby_streaming_delay = 0 and
max_standby_archive_delay = 0.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-13 07:52:07 Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device"
Previous Message Andres Freund 2018-11-13 05:07:27 Re: hot_standby_feedback parameter doesn't work