Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFtI-0002oZ-3x for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Nov 2018 16:32:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gIFtG-0001nY-0K for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Nov 2018 16:32:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFtF-0001nQ-NF for pgsql-hackers@lists.postgresql.org; Thu, 01 Nov 2018 16:32:13 +0000 Received: from smtp-fw-9101.amazon.com ([207.171.184.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gIFtD-0004g9-8s for pgsql-hackers@postgresql.org; Thu, 01 Nov 2018 16:32:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1541089931; x=1572625931; h=from:to:subject:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version; bh=8j9OODZVcgTirq3vETDUau1qjKfPuvfDF4WYrZ9xZ54=; b=rJpsNtZGCOBe53ZxjIqajlWswpwV+OaMcMggh2Q2z5gxjJBRw+L+414f h+UxjxT6amsNSdPYGxCQhQv4/urrnU0U/Sbw9U3SQkpkmRtckWqofYfu3 NnLU89WVLg/GDkiaW442imgrZBKXXZnr9sdI1SXy4F05UbZq97X/Rm7M8 0=; X-IronPort-AV: E=Sophos;i="5.54,452,1534809600"; d="scan'208";a="767811238" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-1d-74cf8b49.us-east-1.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9101.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 01 Nov 2018 16:32:06 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan3.iad.amazon.com [10.40.159.166]) by email-inbound-relay-1d-74cf8b49.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id wA1GW0U4107456 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Thu, 1 Nov 2018 16:32:05 GMT Received: from EX13D03UWC002.ant.amazon.com (10.43.162.160) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Thu, 1 Nov 2018 16:32:04 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC002.ant.amazon.com (10.43.162.160) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Thu, 1 Nov 2018 16:32:04 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1367.000; Thu, 1 Nov 2018 16:32:03 +0000 From: "Bossart, Nathan" To: Masahiko Sawada , PostgreSQL-development Subject: Re: New vacuum option to do only freezing Thread-Topic: New vacuum option to do only freezing Thread-Index: AQHUWXDNCQsPemTbMkmyEyskNumWDaUO0qAAgCdJFwCABN5sgA== Date: Thu, 1 Nov 2018 16:32:03 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.160.235] Content-Type: text/plain; charset="utf-8" Content-ID: <2EEAD22A3CCE2A41A3752654C6D78CE1@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 Precedence: Bulk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGksDQoNCk9uIDEwLzEvMTgsIDU6MjMgQU0sICJNYXNhaGlrbyBTYXdhZGEiIDxzYXdhZGEubXNo a0BnbWFpbC5jb20+IHdyb3RlOg0KPiBBdHRhY2hlZCBwYXRjaCBhZGRzIGEgbmV3IG9wdGlvbiBG UkVFWkVfT05MWSB0byBWQUNVVU0gY29tbWFuZC4gVGhpcw0KPiBvcHRpb24gaXMgc2FtZSBhcyBG UkVFWkUgb3B0aW9uIGV4Y2VwdCBmb3IgaXQgZGlzYWJsZXMgcmVjbGFpbWluZyBkZWFkDQo+IHR1 cGxlcy4gVGhhdCBpcywgd2l0aCB0aGlzIG9wdGlvbiB2YWN1dW0gZG9lcyBwcnVuaW5nIEhPVCBj aGFpbiwNCj4gZnJlZXppbmcgbGl2ZSB0dXBsZXMgYW5kIG1haW50YWluaW5nIGJvdGggdmlzaWJp bGl0eSBtYXAgYW5kIGZyZWVzcGFjZQ0KPiBtYXAgYnV0IGRvZXMgbm90IGNvbGxlY3QgZGVhZCB0 dXBsZXMgYW5kIGludm9rZSBuZWl0aGVyIGhlYXAgdmFjdXVtDQo+IG5vciBpbmRleCB2YWN1dW0u IFRoaXMgb3B0aW9uIHdpbGwgYmUgdXNlZnVsIGlmIHVzZXIgd2FudHMgdG8gcHJldmVudA0KPiBY SUQgd3JhcGFyb3VuZCBhIHRhYmxlIGFzIHF1aWNrIGFzIHBvc3NpYmxlLCBlc3BlY2lhbGx5IHdo ZW4gdGFibGUgaXMNCj4gcXVpdGUgbGFyZ2UgYW5kIGlzIGFib3V0IHRvIFhJRCB3cmFwYXJvdW5k LiBJIHRoaW5rIHRoaXMgdXNlY2FzZSB3YXMNCj4gbWVudGlvbmVkIGluIHNvbWUgdGhyZWFkcyBi dXQgSSBjb3VsZG4ndCBmaW5kIHRoZW0uDQoNCkkndmUgdGhvdWdodCBhYm91dCB0aGlzIGEgYml0 IG15c2VsZi4gIE9uZSBvZiB0aGUgcmVhc29ucyBWQUNVVU0gY2FuDQp0YWtlIHNvIGxvbmcgaXMg YmVjYXVzZSBvZiBhbGwgdGhlIGluZGV4IHNjYW5zIG5lZWRlZC4gIElmIHlvdSdyZSBpbiBhDQpw b3RlbnRpYWwgWElEIHdyYXBhcm91bmQgc2l0dWF0aW9uIGFuZCBqdXN0IG5lZWQgYSBxdWljayB3 YXkgb3V0LCBpdA0Kd291bGQgYmUgbmljZSB0byBoYXZlIGEgd2F5IHRvIGRvIHRoZSBtaW5pbXVt IGFtb3VudCBvZiB3b3JrIG5lY2Vzc2FyeQ0KdG8gcmVjbGFpbSB0cmFuc2FjdGlvbiBJRHMuICBB dCBhIGhpZ2ggbGV2ZWwsIEkgdGhpbmsgdGhlcmUgYXJlIHNvbWUNCmltcHJvdmVtZW50cyB0byB0 aGlzIGRlc2lnbiB3ZSBzaG91bGQgY29uc2lkZXIuDQoNCjEuIENyZWF0ZSBhIHNlcGFyYXRlIEZS RUVaRSBjb21tYW5kIGluc3RlYWQgb2YgYWRkaW5nIGEgbmV3IFZBQ1VVTQ0KICAgb3B0aW9uDQoN ClRoZSBmaXJzdCBsaW5lIG9mIHRoZSBWQUNVVU0gZG9jdW1lbnRhdGlvbiByZWFkcywgIlZBQ1VV TSByZWNsYWltcw0Kc3RvcmFnZSBvY2N1cGllZCBieSBkZWFkIHR1cGxlcywiIHdoaWNoIGlzIHNv bWV0aGluZyB0aGF0IHdlIHdvdWxkDQpleHBsaWNpdGx5IG5vdCBiZSBkb2luZyB3aXRoIEZSRUVa RV9PTkxZLiAgSSB0aGluayBpdCBtYWtlcyBzZW5zZSB0bw0KcmV1c2UgbWFueSBvZiB0aGUgVkFD VVVNIGNvZGUgcGF0aHMgdG8gaW1wbGVtZW50IHRoaXMgZmVhdHVyZSwgYnV0DQpmcm9tIGEgdXNl ciBwZXJzcGVjdGl2ZSwgaXQgc2hvdWxkIGJlIHNlcGFyYXRlLg0KDQoyLiBXZSBzaG91bGQgcmVj bGFpbSB0cmFuc2FjdGlvbiBJRHMgZnJvbSBkZWFkIHR1cGxlcyBhcyB3ZWxsDQoNClVubGVzcyB3 ZSBhbHNvIGhhdmUgYSB3YXkgdG8gZnJlZXplIFhNQVggbGlrZSB3ZSBkbyBYTUlOLCBJIGRvdWJ0 IHRoaXMNCmZlYXR1cmUgd2lsbCBiZSB1c2VmdWwgZm9yIHRoZSBpbW1pbmVudC1YSUQtd3JhcGFy b3VuZCB1c2UtY2FzZS4gIEluDQpzaG9ydCwgd2Ugd29uJ3QgYmUgYWJsZSB0byBhZHZhbmNlIHJl bGZyb3plbnhpZCBhbmQgcmVsbWlubXhpZCBiZXlvbmQNCnRoZSBvbGRlc3QgWE1BWCB2YWx1ZSBm b3IgdGhlIHJlbGF0aW9uLiAgSUlVQyB0aGUgaWRlYSBvZiBmcmVlemluZw0KWE1BWCBkb2Vzbid0 IHJlYWxseSBleGlzdCB5ZXQuICBFaXRoZXIgdGhlIFhNQVggaXMgYWJvcnRlZC9pbnZhbGlkIGFu ZA0KY2FuIGJlIHJlc2V0IHRvIEludmFsaWRUcmFuc2FjdGlvbklkLCBvciBpdCBpcyBjb21taXR0 ZWQgYW5kIHRoZSB0dXBsZQ0KY2FuIGJlIHJlbW92ZWQgaWYgaXQgYmV5b25kIHRoZSBmcmVlemlu ZyB0aHJlc2hvbGQuICBTbywgd2UgcHJvYmFibHkNCmFsc28gd2FudCB0byBsb29rIGludG8gYWRk aW5nIGEgd2F5IHRvIGZyZWV6ZSBYTUFYLCBlaXRoZXIgYnkgc2V0dGluZw0KaXQgdG8gRnJvemVu VHJhbnNhY3Rpb25JZCBvciBieSBzZXR0aW5nIHRoZSBoaW50IGJpdHMgdG8NCihIRUFQX1hNQVhf Q09NTUlUVEVEIHwgSEVBUF9YTUlOX0lOVkFMSUQpIGFzIGlzIGRvbmUgZm9yIFhNSU4uDQoNCkxv b2tpbmcgY2xvc2VyLCBJIHNlZSB0aGF0IHRoZSBwaHJhc2UgImZyZWV6aW5nIFhNQVgiIGlzIGN1 cnJlbnRseQ0KdXNlZCB0byByZWZlciB0byBzZXR0aW5nIGl0IHRvIEludmFsaWRUcmFuc2FjdGlv bklkIGlmIGl0IGlzIGFib3J0ZWQNCm9yIGludmFsaWQgKGUuZy4gbG9jay1vbmx5KS4NCg0KPiBD dXJyZW50bHkgdGhpcyBwYXRjaCBqdXN0IGFkZHMgdGhlIG5ldyBvcHRpb24gdG8gVkFDVVVNIGNv bW1hbmQgYnV0IGl0DQo+IG1pZ2h0IGJlIGdvb2QgdG8gbWFrZSBhdXRvdmFjdXVtIHVzZSBpdCB3 aGVuIGVtZXJnZW5jeSB2YWN1dW0gaXMNCj4gcmVxdWlyZWQuDQoNClRoaXMgYWxzbyBzZWVtcyBs aWtlIGEgdmFsaWQgdXNlLWNhc2UsIGJ1dCBpdCBzaG91bGQgZGVmaW5pdGVseSBiZQ0KZG9uZSBh cyBhIHNlcGFyYXRlIGVmZm9ydCBhZnRlciB0aGlzIGZlYXR1cmUgaGFzIGJlZW4gY29tbWl0dGVk Lg0KDQo+IFRoaXMgaXMgYSBwZXJmb3JtYW5jZS10ZXN0IHJlc3VsdCBmb3IgRlJFRVpFIG9wdGlv biBhbmQgRlJFRVpFX09OTFkNCj4gb3B0aW9uLiBJJ3ZlIHRlc3RlZCB0aGVtIG9uIHRoZSB0YWJs ZSB3aGljaCBpcyBhYm91dCAzLjhHQiB0YWJsZQ0KPiB3aXRob3V0IGluZGV4ZXMgYW5kIHJhbmRv bWx5IG1vZGlmaWVkLg0KPg0KPiAqIEZSRUVaRQ0KPiAuLi4NCj4gVGltZTogNTAzMDEuMjYyIG1z ICgwMDo1MC4zMDEpDQo+DQo+ICogRlJFRVpFX09OTFkNCj4gLi4uDQo+IFRpbWU6IDQ0NTg5Ljc5 NCBtcyAoMDA6NDQuNTkwKQ0KDQpJJ2QgYmUgY3VyaW91cyB0byBzZWUgdGhlIGltcHJvdmVtZW50 cyB5b3UgZ2V0IHdoZW4gdGhlcmUgYXJlIHNldmVyYWwNCmluZGV4ZXMgb24gdGhlIHJlbGF0aW9u LiAgVGhlIGFiaWxpdHkgdG8gc2tpcCB0aGUgaW5kZXggc2NhbnMgaXMNCmxpa2VseSBob3cgdGhp cyBmZWF0dXJlIHdpbGwgcmVhbGx5IGhlbHAgc3BlZWQgdGhpbmdzIHVwLg0KDQpOYXRoYW4NCg0K