Re: Vacuum of large tables causing replication delays to hot standby

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Mcdowell <Jeff(dot)Mcdowell(at)panerabread(dot)com>
Cc: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum of large tables causing replication delays to hot standby
Date: 2016-04-30 17:37:13
Message-ID: 22825.1462037833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Mcdowell <Jeff(dot)Mcdowell(at)panerabread(dot)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 dont 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2016-04-30 17:45:42 Re: Vacuum of large tables causing replication delays to hot standby
Previous Message David G. Johnston 2016-04-30 17:01:44 Re: Why don't custom GUCs show in pg_settings?