Re: Vacuum of large tables causing replication delays to hot standby - Mailing list pgsql-general

From Tom Lane
Subject Re: Vacuum of large tables causing replication delays to hot standby
Date
Msg-id 22825.1462037833@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum of large tables causing replication delays to hot standby  (Jeff Mcdowell <Jeff.Mcdowell@panerabread.com>)
Responses Re: Vacuum of large tables causing replication delays to hot standby
Re: Vacuum of large tables causing replication delays to hot standby
List pgsql-general
Jeff Mcdowell <Jeff.Mcdowell@panerabread.com> writes:
> 95% of the time, the delay is only microseconds. But we have discovered that whenever the master does an auto vacuum
ofa large table, the transaction replay delay can climb is high as 1 hour. These delays don�t seem to correlate with
anyparticular queries that are running against the master or the standby, and the delay only subsides when the vacuum
completes.

What PG version might this be?

            regards, tom lane


pgsql-general by date:

Previous
From: Jeff Mcdowell
Date:
Subject: Vacuum of large tables causing replication delays to hot standby
Next
From: Alvaro Herrera
Date:
Subject: Re: Vacuum of large tables causing replication delays to hot standby