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 1gz3Hc-0005KW-MW for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Feb 2019 17:46: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 1gz3Hb-0006fC-Ij for pgsql-hackers@arkaria.postgresql.org; Wed, 27 Feb 2019 17:46:15 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz3Hb-0006cu-AJ for pgsql-hackers@lists.postgresql.org; Wed, 27 Feb 2019 17:46:15 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz3HZ-000761-0g for pgsql-hackers@postgresql.org; Wed, 27 Feb 2019 17:46:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1551289572; x=1582825572; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=75dn2by0KNd7vBt/xM0CiCn3+ME5G1kQS4GEjXFDRBw=; b=NY0XqZavrdoWrHXrl9hJRCG2MW9HVurxHmiXvt52SG2ehX+SNOtJRame r/GbclirO3Xkdl7AzYwHnAkImp3CdRG3gPLplGr84oYhKqNa3/V/ezHxf 82wxKBJ1LRxRiVzvWI7LPR2FF8urQU3XAgfmvdRFG2BirjWnyoOJgurno 8=; X-IronPort-AV: E=Sophos;i="5.58,420,1544486400"; d="scan'208";a="719745441" Received: from iad6-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-1e-97fdccfd.us-east-1.amazon.com) ([10.124.125.2]) by smtp-border-fw-out-2101.iad2.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 27 Feb 2019 17:45:51 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan2.iad.amazon.com [10.40.159.162]) by email-inbound-relay-1e-97fdccfd.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id x1RHjgR2031960 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Wed, 27 Feb 2019 17:45:49 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; Wed, 27 Feb 2019 17:45:48 +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; Wed, 27 Feb 2019 17:45:48 +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, 27 Feb 2019 17:45:48 +0000 From: "Bossart, Nathan" To: Masahiko Sawada CC: Alvaro Herrera , Robert Haas , "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+AgACMlACAYFUDAIAA4DoAgAEBZgCAAZpIgIAAzSeAgAU784CAAS4SAIAAynmAgACHOoCAAPDVgIACb70AgAQS6YCAEZMlgIABqQyAgAHyBICAAQVNgIAi0J0AgAEdq4D///rEgA== Date: Wed, 27 Feb 2019 17:45:47 +0000 Message-ID: <631670BB-CE95-40B5-9550-3C10417862FA@amazon.com> References: <0EA5A139-A127-416B-963F-6301F9F8B75D@amazon.com> <201902021604.zimvqvgmo672@alvherre.pgsql> <6C4C0FC7-5E3A-44C0-90E3-492DAC1183F0@amazon.com> 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.162.120] Content-Type: text/plain; charset="utf-8" Content-ID: <108D37022F5BD1469DB528DAAE2E0CD6@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 T24gMi8yNy8xOSwgMjowOCBBTSwgIk1hc2FoaWtvIFNhd2FkYSIgPHNhd2FkYS5tc2hrQGdtYWls LmNvbT4gd3JvdGU6DQo+PiArICAgICAgIGlmIChza2lwX2luZGV4X3ZhY3V1bSkNCj4+ICsgICAg ICAgICAgICAgICBhcHBlbmRTdHJpbmdJbmZvKCZidWYsIG5nZXR0ZXh0KCIlLjBmIHR1cGxlIGlz IGxlZnQgYXMgZGVhZC5cbiIsDQo+PiArICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICIlLjBmIHR1cGxl cyBhcmUgbGVmdCBhcyBkZWFkLlxuIiwNCj4+ICsgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbmxlZnQp LA0KPj4gKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIG5s ZWZ0KTsNCj4+DQo+PiBJIHRoaW5rIHdlIGNvdWxkIGVtaXQgdGhpcyBtZXRyaWMgZm9yIGFsbCBj YXNlcywgbm90IG9ubHkgd2hlbg0KPj4gRElTQUJMRV9JTkRFWF9DTEVBTlVQIGlzIHVzZWQuDQo+ DQo+IEkgdGhpbmsgdGhhdCB0dXBzX3ZhY3V1bWVkIHNob3dzIHRvdGFsIG51bWJlciBvZiB2YWN1 dW1lZCB0dXBsZXMgYW5kDQo+IGlzIGFscmVhZHkgc2hvd24gaW4gdGhlIGxvZyBtZXNzYWdlLiBU aGUgJ25sZWZ0JyBjb3VudHMgdGhlIHRvdGFsDQo+IG51bWJlciBvZiByZWNvcmRlZCBkZWFkIHR1 cGxlIGJ1dCBub3QgY291bnRzIHR1cGxlcyBhcmUgcmVtb3ZlZCBkdXJpbmcNCj4gSE9ULXBydW5p bmcuIElzIHRoaXMgYSB2YWx1YWJsZSBmb3IgdXNlcnMgaW4gbm9uLURJU0FCTEVfSU5ERVhfQ0xF QU5VUA0KPiBjYXNlPw0KDQpJIHRoaW5rIGl0IGlzIHZhbHVhYmxlLiAgV2hlbiBESVNBQkxFX0lO REVYX0NMRUFOVVAgaXMgbm90IHVzZWQgb3IgaXQNCmlzIHVzZWQgZm9yIGEgcmVsYXRpb24gd2l0 aCBubyBpbmRleGVzLCBpdCBtYWtlcyBpdCBjbGVhciB0aGF0IG5vDQp0dXBsZXMgd2VyZSBsZWZ0 IG1hcmtlZCBhcyBkZWFkLiAgQWxzbywgaXQgbG9va3MgbGlrZSBhbGwgb2YgdGhlIG90aGVyDQpp bmZvcm1hdGlvbiBoZXJlIGlzIHByb3ZpZGVkIHJlZ2FyZGxlc3Mgb2YgdGhlIG9wdGlvbnMgdXNl ZC4gIElNTyBpdA0KaXMgZ29vZCB0byBsaXN0IGFsbCBvZiB0aGUgc3RhdHMgc28gdGhhdCB1c2Vy cyBoYXZlIHRoZSBmdWxsIHBpY3R1cmUNCm9mIHdoYXQgVkFDVVVNIGRpZC4NCg0KTmF0aGFuDQoN Cg==