Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghKPE-0006sW-SX for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Jan 2019 20:24:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghKOF-0003EO-Kk for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Jan 2019 20:23:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghKOF-0003A3-6v for pgsql-hackers@lists.postgresql.org; Wed, 09 Jan 2019 20:23:51 +0000 Received: from smtp-fw-4101.amazon.com ([72.21.198.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghKOC-0001G4-Ix for pgsql-hackers@postgresql.org; Wed, 09 Jan 2019 20:23:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1547065428; x=1578601428; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=vT++rN6m56mxA7/uwNLTulWbSR1pnaSR6gx1rSf4j4E=; b=R0FEqBjSQL8/nZXRHIgmp3nq4cH7+1bAtM7selX79N9BqEQw8zMd6p+9 nF6UHCiYhgI/wKP44DaZPQd6NuW/WFEYBRRDfxuYefkYpackAtQxfDTWN 7FxK0BIVg/EvNgO5sPoTlo4Oo1FChwaEW3sSOu+lCzniX4Ra99xyz7RjK A=; X-IronPort-AV: E=Sophos;i="5.56,253,1539648000"; d="scan'208";a="753327568" Received: from iad6-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-2b-55156cd4.us-west-2.amazon.com) ([10.124.125.6]) by smtp-border-fw-out-4101.iad4.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 09 Jan 2019 20:23:46 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-2b-55156cd4.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id x09KNjgp082494 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Wed, 9 Jan 2019 20:23:46 GMT Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 9 Jan 2019 20:23:45 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC003.ant.amazon.com (10.43.162.79) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Wed, 9 Jan 2019 20:23:46 +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; Wed, 9 Jan 2019 20:23:45 +0000 From: "Bossart, Nathan" To: Masahiko Sawada , Robert Haas CC: "pgsql-hackers@postgresql.org" Subject: Re: New vacuum option to do only freezing Thread-Topic: New vacuum option to do only freezing Thread-Index: AQHUWXDNCQsPemTbMkmyEyskNumWDaU7Vk2AgAW0QwCAAKIIAIAELI+AgACMlACAYFUDAIAA4DoA Date: Wed, 9 Jan 2019 20:23:44 +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.173] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 Precedence: Bulk List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGksDQoNCk9uIDEvOC8xOSwgNzowMyBQTSwgIk1hc2FoaWtvIFNhd2FkYSIgPHNhd2FkYS5tc2hr QGdtYWlsLmNvbT4gd3JvdGU6DQo+IEF0dGFjaGVkIHRoZSB1cGRhdGVkIHZlcnNpb24gcGF0Y2gg aW5jb3Jwb3JhdGVkIGFsbCBjb21tZW50cyBJIGdvdC4NCg0KVGhhbmtzIGZvciB0aGUgbmV3IHBh dGNoIQ0KDQo+ICogSW5zdGVhZCBvZiBmcmVlemluZyB4bWF4IEkndmUgY2hhbmdlZCB0aGUgYmVo YXZpb3VyIG9mIHRoZSBuZXcNCj4gb3B0aW9uIChESVNBQkxFX0lOREVYX0NMRUFOVVApIHNvIHRo YXQgaXQgc2V0cyBkZWFkIHR1cGxlcyBhcyBkZWFkDQo+IGluc3RlYWQgb2YgYXMgdW51c2VkIGFu ZCBza2lwcyBib3RoIGluZGV4IHZhY3V1bSBhbmQgaW5kZXggY2xlYW51cC4NCj4gVGhhdCBpcywg d2UgcmVtb3ZlIHRoZSBzdG9yYWdlIG9mIGRlYWQgdHVwbGUgYnV0IGxlYXZlIGRlYWQgaXRlbWlk cw0KPiBmb3IgdGhlIGluZGV4IGxvb2t1cHMuIFRoZXNlIGFyZSByZW1vdmVkIGJ5IHRoZSBuZXh0 IHZhY3V1bSBleGVjdXRpb24NCj4gZW5hYmxpbmcgaW5kZXggY2xlYW51cC4gQ3VycmVudGx5IEhP VC1wcnVuaW5nIGRvZXNuJ3Qgc2V0IHRoZSByb290IG9mDQo+IHRoZSBjaGFpbiBhcyB1bnVzZWQg ZXZlbiBpZiB0aGUgd2hvbGUgY2hhaW4gaXMgZGVhZC4gU2luY2Ugc2V0dGluZw0KPiB0dXBsZXMg YXMgZGVhZCByZW1vdmVzIHN0b3JhZ2UgdGhlIGZyZWV6aW5nIHhtYXggaXMgbm8gbG9uZ2VyDQo+ IHJlcXVpcmVkLg0KDQpJIHRlc3RlZCB0aGlzIG9wdGlvbiB3aXRoIGEgdmFyaWV0eSBvZiBjYXNl cyAoSE9ULCBpbmRleGVzLCBldGMuKSwgYW5kDQppdCBzZWVtcyB0byB3b3JrIHdlbGwuICBJIGhh dmVuJ3QgbG9va2VkIHRvbyBkZWVwbHkgaW50byB0aGUNCmltcGxpY2F0aW9ucyBvZiB1c2luZyBM UF9ERUFEIHRoaXMgd2F5LCBidXQgaXQgc2VlbXMgbGlrZSBhIHJlYXNvbmFibGUNCmFwcHJvYWNo IGF0IGZpcnN0IGdsYW5jZS4NCg0KKyAgICA8dmFybGlzdGVudHJ5Pg0KKyAgICA8dGVybT48bGl0 ZXJhbD5ESVNBQkxFX0lOREVYX0NMRUFOVVA8L2xpdGVyYWw+PC90ZXJtPg0KKyAgICA8bGlzdGl0 ZW0+DQorICAgICA8cGFyYT4NCisgICAgICA8Y29tbWFuZD5WQUNVVU08L2NvbW1hbmQ+IHJlbW92 ZXMgZGVhZCB0dXBsZXMgYW5kIHBydW5lcyBIT1QtdXBkYXRlZA0KKyAgICAgIHR1cGxlcyBjaGFp biBmb3IgbGl2ZSB0dXBsZXMgb24gdGFibGUuIElmIHRoZSB0YWJsZSBoYXMgYW55IGRlYWQgdHVw bGUNCisgICAgICBpdCByZW1vdmVzIHRoZW0gZnJvbSBib3RoIHRhYmxlIGFuZCBpbmRleGVzIGZv ciByZS11c2UuIFdpdGggdGhpcw0KKyAgICAgIG9wdGlvbiA8Y29tbWFuZD5WQUNVVU08L2NvbW1h bmQ+IG1hcmtzIHR1cGxlcyBhcyBkZWFkIChpLmUuLCBpdCBkb2Vzbid0DQorICAgICAgcmVtb3Zl IHR1cGxlIHN0b3JhZ2UpIGFuZCBkaXNhYmxlcyByZW1vdmluZyBkZWFkIHR1cGxlcyBmcm9tIGlu ZGV4ZXMuDQorICAgICAgVGhpcyBpcyBzdWl0YWJsZSBmb3IgYXZvaWRpbmcgdHJhbnNhY3Rpb24g SUQgd3JhcGFyb3VuZCBidXQgbm90DQorICAgICAgc3VmZmljaWVudCBmb3IgYXZvaWRpbmcgaW5k ZXggYmxvYXQuIFRoaXMgb3B0aW9uIGNhbm5vdCBiZSB1c2VkIGluDQorICAgICAgY29uanVuY3Rp b24gd2l0aCA8bGl0ZXJhbD5GVUxMPC9saXRlcmFsPiBvcHRpb24uDQorICAgICA8L3BhcmE+DQor ICAgIDwvbGlzdGl0ZW0+DQorICAgPC92YXJsaXN0ZW50cnk+DQoNCkkgdGhpbmsgd2Ugc2hvdWxk IGNsYXJpZnkgdGhlIGV4cGVjdGVkIGJlaGF2aW9yIHdoZW4gdGhpcyBvcHRpb24gaXMNCnVzZWQg b24gYSB0YWJsZSB3aXRoIG5vIGluZGV4ZXMuICBXZSBwcm9iYWJseSBkbyBub3Qgd2FudCB0byBm YWlsLCBhcw0KdGhpcyBjb3VsZCBkaXNydXB0IFZBQ1VVTSBjb21tYW5kcyB0aGF0IHRvdWNoIHNl dmVyYWwgdGFibGVzLiAgQWxzbywNCndlIGRvbid0IG5lZWQgdG8gc2V0IHR1cGxlcyBhcyBkZWFk IGluc3RlYWQgb2YgdW51c2VkLCB3aGljaCBhcHBlYXJzDQp0byBiZSB3aGF0IHRoaXMgcGF0Y2gg aXMgYWN0dWFsbHkgZG9pbmc6DQoNCisgICAgICAgICAgICAgICAgICAgICAgIGlmIChuaW5kZXhl cyA+IDAgJiYgZGlzYWJsZV9pbmRleF9jbGVhbnVwKQ0KKyAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBsYXp5X3NldF90dXBsZXNfZGVhZChvbmVyZWwsIGJsa25vLCBidWYsIHZhY3JlbHN0 YXRzKTsNCisgICAgICAgICAgICAgICAgICAgICAgIGVsc2UNCisgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgbGF6eV92YWN1dW1fcGFnZShvbmVyZWwsIGJsa25vLCBidWYsIDAsIHZhY3Jl bHN0YXRzLCAmdm1idWZmZXIpOw0KDQpJbiB0aGlzIGNhc2UsIHBlcmhhcHMgd2Ugc2hvdWxkIGdl bmVyYXRlIGEgbG9nIHN0YXRlbWVudCB0aGF0IG5vdGVzDQp0aGF0IERJU0FCTEVfSU5ERVhfQ0xF QU5VUCBpcyBiZWluZyBpZ25vcmVkIGFuZCBzZXQNCmRpc2FibGVfaW5kZXhfY2xlYW51cCB0byBm YWxzZSBkdXJpbmcgcHJvY2Vzc2luZy4NCg0KKyAgICAgICAgICAgICAgIGlmIChkaXNhYmxlX2lu ZGV4X2NsZWFudXApDQorICAgICAgICAgICAgICAgICAgICAgICBlcmVwb3J0KGVsZXZlbCwNCisg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAoZXJybXNnKCJcIiVzXCI6IG1h cmtlZCAlLjBmIHJvdyB2ZXJzaW9ucyBpbiAldSBwYWdlcyBhcyBkZWFkIiwNCisgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVsYXRpb25HZXRS ZWxhdGlvbk5hbWUob25lcmVsKSwNCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgdHVwc192YWN1dW1lZCwgdmFjdXVtZWRfcGFnZXMpKSk7DQor ICAgICAgICAgICAgICAgZWxzZQ0KKyAgICAgICAgICAgICAgICAgICAgICAgZXJlcG9ydChlbGV2 ZWwsDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgKGVycm1zZygiXCIl c1wiOiByZW1vdmVkICUuMGYgcm93IHZlcnNpb25zIGluICV1IHBhZ2VzIiwNCisgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVsYXRpb25HZXRS ZWxhdGlvbk5hbWUob25lcmVsKSwNCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgdHVwc192YWN1dW1lZCwgdmFjdXVtZWRfcGFnZXMpKSk7DQoN ClNob3VsZCB0aGUgZmlyc3QgbG9nIHN0YXRlbWVudCBvbmx5IGJlIGdlbmVyYXRlZCB3aGVuIHRo ZXJlIGFyZSBhbHNvDQppbmRleGVzPw0KDQorc3RhdGljIHZvaWQNCitsYXp5X3NldF90dXBsZXNf ZGVhZChSZWxhdGlvbiBvbmVyZWwsIEJsb2NrTnVtYmVyIGJsa25vLCBCdWZmZXIgYnVmZmVyLA0K KyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIExWUmVsU3RhdHMgKnZhY3Jl bHN0YXRzKQ0KDQpUaGlzIGZ1bmN0aW9uIGxvb2tzIHZlcnkgc2ltaWxhciB0byBsYXp5X3ZhY3V1 bV9wYWdlKCkuICBQZXJoYXBzIHRoZQ0KdHdvIGNvdWxkIGJlIGNvbWJpbmVkPw0KDQpOYXRoYW4N Cg0K