think about it, I wonder if the lag may have
arisen from IO contention between the query and WAL replay, rather than
a query conflict.
Also, check this out:
https://www.alibabacloud.com/forum/read-383
Thanks, interesting reading.
Am Mo., 19. Nov. 2018 um 21:46 Uhr schrieb Wyatt Alt
mailto
On 11/19/18 11:09 PM, Laurenz Albe wrote:
With these settings, any conflicting query will be canceled after five
minutes. Perhaps your actual settings are different.
What do you get for
SELECT * FROM pg_settings WHERE name = 'max_standby_streaming_delay';
Hi Laurenz, thanks for backing up m
ginal question, are there causes of replication lag that
max_standby_streaming_delay would not be expected to prevent, that would be
resolved by killing long standby queries? If so, what's the best way to
confirm?
Wyatt
On Mon, Nov 19, 2018 at 5:46 PM Wyatt Alt wrote:
> I've been strug
I've been struggling to eliminate replication lag on a Postgres 9.6.6
instance on Amazon RDS. I believe the lag is caused by early cleanup
conflicts from vacuums on the master, because I can reliably resolve it by
killing long-running queries on the standby. I most recently saw ten hours
of lag on
