[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Vacuum of large tables causing replication delays to hot standby
From:       Jeff Mcdowell <Jeff.Mcdowell () panerabread ! com>
Date:       2016-04-30 19:03:02
Message-ID: 93F1623A-31D9-4BDF-9E17-DC20BF10B184 () panerabread ! com
[Download RAW message or body]

9.2.12

Sent from my iPhone

> On Apr 30, 2016, at 12:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> 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 of a large table, the transaction replay \
> > delay can climb is high as 1 hour. These delays don’t seem to correlate with any \
> > particular 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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[prev in list] [next in list] [prev in thread] [next in thread]