Re: Remove vacuum_defer_cleanup_age - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Remove vacuum_defer_cleanup_age
Date
Msg-id 20161020010901.GA20259@momjian.us
Whole thread Raw
In response to Re: Remove vacuum_defer_cleanup_age  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Remove vacuum_defer_cleanup_age  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Oct 19, 2016 at 08:17:46PM -0400, Robert Haas wrote:
> On Wed, Oct 19, 2016 at 12:59 PM, Bruce Momjian <bruce@momjian.us> wrote:
> > Uh, vacuum_defer_cleanup_age sets an upper limit on how long, in terms
> > of xids, that a standby query can run before cancel, like
> > old_snapshot_threshold, no?
> 
> No, not really.  It affects the behavior of the master, not the standby.

But it controls when/if cancels happen on the standby.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: On conflict update & hint bits
Next
From: "Joshua D. Drake"
Date:
Subject: Disable autovacuum guc?