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 1gp25P-0000AV-2o for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Jan 2019 02:28:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gp25N-0004aG-0k for pgsql-hackers@arkaria.postgresql.org; Thu, 31 Jan 2019 02:28:13 +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 1gp25M-0004Wj-NO for pgsql-hackers@lists.postgresql.org; Thu, 31 Jan 2019 02:28:12 +0000 Received: from smtp-fw-6002.amazon.com ([52.95.49.90]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gp25K-0007mJ-3S for pgsql-hackers@postgresql.org; Thu, 31 Jan 2019 02:28:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1548901690; x=1580437690; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=7GsB5JWxCG0hhYAQNGJHo2jpwuOXI2MYy9wcjlJ6JGk=; b=GXHMY9x8QmQqpZTmmrxfLDboGsH96QYDVnTbIDBgpsO9tOOQgelmuLYf O6P/9sVgqVYBvXApFQXOn87bt0ekvYvmKj0374cETExiZSjHG5SkinHDy RWSInRJeYGxcY8kdHxScWOpAmsFuLDgZT8WF2kqNvhwijJdGnAo8Ix3/k M=; X-IronPort-AV: E=Sophos;i="5.56,542,1539648000"; d="scan'208";a="384350704" Received: from iad6-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-2a-1c1b5cdd.us-west-2.amazon.com) ([10.124.125.6]) by smtp-border-fw-out-6002.iad6.amazon.com with ESMTP; 31 Jan 2019 02:28:07 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-2a-1c1b5cdd.us-west-2.amazon.com (Postfix) with ESMTPS id C4D44A21FF; Thu, 31 Jan 2019 02:28:06 +0000 (UTC) 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, 31 Jan 2019 02:28:06 +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, 31 Jan 2019 02:28:06 +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, 31 Jan 2019 02:28:06 +0000 From: "Bossart, Nathan" To: Michael Paquier CC: Masahiko Sawada , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: A few new options for vacuumdb Thread-Topic: A few new options for vacuumdb Thread-Index: AQHUl9xu8aMC9yfhG06pgjLAC3hejaWG4TQAgACSAwCAAfejgP//oXAAgBZvvQCABCXhgIABGu8AgACztICAAM7ggIAAB18AgAAyXQCAAU97AIASLWaAgAELwgCAAJrMAIAAzqiAgADcPYCAByVfAIAAhkgAgADTugCAALv/AIAAuAGAgACWnwCAAREkgP//gLyA Date: Thu, 31 Jan 2019 02:28:05 +0000 Message-ID: References: <20190122060730.GD8719@paquier.xyz> <20190123034111.GH3873@paquier.xyz> <26A57CB3-2847-495F-93CA-9358959CDAD4@amazon.com> <20190128055702.GB15401@paquier.xyz> <20190129023526.GA3121@paquier.xyz> <32049A78-C429-4742-AEC1-941C9ABDE7B8@amazon.com> <20190130004653.GK3121@paquier.xyz> <5E292853-2CC1-4D7A-9613-7A6ED049CE49@amazon.com> <20190131020335.GF16781@paquier.xyz> In-Reply-To: <20190131020335.GF16781@paquier.xyz> 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.96] Content-Type: text/plain; charset="utf-8" Content-ID: <556977C47CA12E409178F5F5C6D8661C@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 T24gMS8zMC8xOSwgNjowNCBQTSwgIk1pY2hhZWwgUGFxdWllciIgPG1pY2hhZWxAcGFxdWllci54 eXo+IHdyb3RlOg0KPiBTb21ldGhpbmcgd2hpY2ggd2FzIG5vdCBjb3JyZWN0IGluIHRoZSBwYXRj aCBpcyB0aGUgY29tcGF0aWJpbGl0eSBvZg0KPiB0aGUgcXVlcnkuICB4aWQgPD4geGlkIGhhcyBi ZWVuIGFkZGVkIGluIDkuNiwgc28gdGhlIG5ldyBvcHRpb25zIHdpbGwNCj4gbm90IGJlIGFibGUg dG8gd29yayB3aXRoIG9sZGVyIHZlcnNpb25zLiAgVGhlIHZlcnNpb25zIG1hcmtlZCBhcw0KPiBj b21wYXRpYmxlIGluIHRoZSBsYXN0IHBhdGNoIGNhbWUgZnJvbSB0aGUgYWdlLWluZyBmdW5jdGlv bnMsIGJ1dCB5b3UNCj4gYWRkZWQgZGlyZWN0IGNvbXBhcmlzb25zIHdpdGggcmVsZnJvemVueGlk IGFuZCByZWxtaW5teGlkIGluIHRoZQ0KPiBsYXRlc3QgdmVyc2lvbnMgb2YgdGhlIHBhdGNoLiAg VGhpcyBpbXBsZW1lbnRhdGlvbiBnb2VzIGRvd24gYSBjb3VwbGUNCj4gb2YgcmVsZWFzZWQgdmVy c2lvbnMsIHdoaWNoIGlzIHVzZWZ1bCBlbm91Z2ggaW4gbXkgb3Bpbmlvbiwgc28gSSB3b3VsZA0K PiBrZWVwIGl0IGFzLWlzLg0KDQpBZ3JlZWQuICBUaGFua3MgZm9yIGNhdGNoaW5nIHRoaXMuDQoN Cj4gSSBoYXZlIGFkZGVkIGFzIHdlbGwgc29tZSBtYXJrdXBzIGFyb3VuZCAiUG9zdGdyZVNRTCIg aW4gdGhlIGRvY3MsIGFuZA0KPiBleHRyYSBjYXN0cyBmb3IgdGhlIGludGVnZXIveGlkIHZhbHVl cyBvZiB0aGUgcXVlcnkuICBUaGUgdGVzdA0KPiBwYXR0ZXJucyBhcmUgYWxzbyBzaW1wbGlmaWVk LCBhbmQgSSBhZGRlZCB0ZXN0cyBmb3IgaW5jb3JyZWN0IHZhbHVlcw0KPiBvZiAtLW1pbi14aWQt YWdlIGFuZCAtLW1pbi1teGlkLWFnZS4gIERvZXMgdGhhdCBsb29rIGNvcnJlY3QgdG8geW91Pw0K DQpJdCBsb29rcyBnb29kIHRvIG1lLiAgVGhlIG9ubHkgdGhpbmcgSSBub3RpY2VkIGlzIHRoZSB1 c2Ugb2YNCnJlbGZyb3plbnhpZCBpbnN0ZWFkIG9mIHJlbG1pbm14aWQgaGVyZToNCg0KKyAgICAg ICAgICAgICAgIGFwcGVuZFBRRXhwQnVmZmVyKCZjYXRhbG9nX3F1ZXJ5LA0KKyAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiICVzIEdSRUFURVNUKHBnX2Nh dGFsb2cubXhpZF9hZ2UoYy5yZWxtaW5teGlkKSwiDQorICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICIgcGdfY2F0YWxvZy5teGlkX2FnZSh0LnJlbG1pbm14 aWQpKSBPUEVSQVRPUihwZ19jYXRhbG9nLj49KSINCisgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIiAnJWQnOjpwZ19jYXRhbG9nLmludDRcbiINCisgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIiBBTkQgYy5yZWxm cm96ZW54aWQgT1BFUkFUT1IocGdfY2F0YWxvZy4hPSkiDQorICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICIgJzAnOjpwZ19jYXRhbG9nLnhpZFxuIiwNCisg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgaGFzX3doZXJl ID8gIkFORCIgOiAiV0hFUkUiLCB2YWNvcHRzLT5taW5fbXhpZF9hZ2UpOw0KDQpIb3dldmVyLCB0 aGF0IG1heSBzdGlsbCB3b3JrIGFzIGludGVuZGVkLg0KDQpOYXRoYW4NCg0K