[GENERAL] Vacuum of large tables causing replication delays to hot standby

2016-04-30 Thread Jeff Mcdowell
lay only subsides when the vacuum completes. Does anyone have any recommendations for a configuration that can minimize the replay delays that occur during the vacuums of large tables. -- Thank you, Jeff McDowell Email: jeff.mcdow...@panerabread.com

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

2016-04-30 Thread Jeff Mcdowell
9.2.12 Sent from my iPhone > On Apr 30, 2016, at 12:37 PM, Tom Lane wrote: > > Jeff Mcdowell 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 >> rep