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 1ga1Um-0002dr-63 for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Dec 2018 16:48:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ga1Uk-00010D-UM for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Dec 2018 16:48:22 +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 1ga1Uk-0000xH-IC for pgsql-hackers@lists.postgresql.org; Thu, 20 Dec 2018 16:48:22 +0000 Received: from smtp-fw-9101.amazon.com ([207.171.184.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ga1Ud-0007X9-Pi for pgsql-hackers@postgresql.org; Thu, 20 Dec 2018 16:48:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1545324493; x=1576860493; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=PPLC467tK0bPNTIAPcNrwtrbjtc2D2+cQIZYzVgTgK8=; b=Ma90VVuBqpslSacJUm9/EcUwkIDkgDjdjJIiMRr+omVwcrhMsRlDqGgg 6nFp7CooV1E+G2nKa4SerzxOqJBKs5k69TsV4heyvPian3NIqwDQdxPhe /Ts5bfv2qbCWaMKTTmKvjqtEWNCXR8wyenK7elH+LhgNHVjx8/N+JUQ9z k=; X-IronPort-AV: E=Sophos;i="5.56,253,1539648000"; d="scan'208";a="777416995" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-2b-4ff6265a.us-west-2.amazon.com) ([10.47.22.38]) by smtp-border-fw-out-9101.sea19.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 20 Dec 2018 16:48:11 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-2b-4ff6265a.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id wBKGmAk3098111 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Thu, 20 Dec 2018 16:48:12 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; Thu, 20 Dec 2018 16:48:11 +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; Thu, 20 Dec 2018 16:48:11 +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, 20 Dec 2018 16:48:11 +0000 From: "Bossart, Nathan" To: Michael Paquier CC: "pgsql-hackers@postgresql.org" Subject: Re: A few new options for vacuumdb Thread-Topic: A few new options for vacuumdb Thread-Index: AQHUl9xu8aMC9yfhG06pgjLAC3hejaWG4TQAgACSAwA= Date: Thu, 20 Dec 2018 16:48:11 +0000 Message-ID: <7B4ACE8E-5D81-416B-B984-17E60F7ABABA@amazon.com> References: <20181220020522.GM27104@paquier.xyz> In-Reply-To: <20181220020522.GM27104@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.160.211] 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 SGkgTWljaGFlbCwNCg0KVGhhbmtzIGZvciB0YWtpbmcgYSBsb29rLg0KDQpPbiAxMi8xOS8xOCwg ODowNSBQTSwgIk1pY2hhZWwgUGFxdWllciIgPG1pY2hhZWxAcGFxdWllci54eXo+IHdyb3RlOg0K PiBPbiBXZWQsIERlYyAxOSwgMjAxOCBhdCAwODo1MDoxMFBNICswMDAwLCBCb3NzYXJ0LCBOYXRo YW4gd3JvdGU6DQo+PiBJZiBhbiBvcHRpb24gaXMgc3BlY2lmaWVkIGZvciBhIHNlcnZlciB2ZXJz aW9uIHRoYXQgaXMgbm90IHN1cHBvcnRlZCwNCj4+IHRoZSBvcHRpb24gaXMgc2lsZW50bHkgaWdu b3JlZC4gIEZvciBleGFtcGxlLCBTS0lQX0xPQ0tFRCB3YXMgb25seQ0KPj4gYWRkZWQgdG8gVkFD VVVNIGFuZCBBTkFMWVpFIGZvciB2MTIuICBBbHRlcm5hdGl2ZWx5LCBJIHRoaW5rIHdlIGNvdWxk DQo+PiBmYWlsIGluIHZhY3V1bV9vbmVfZGF0YWJhc2UoKSBpZiBhbiB1bnN1cHBvcnRlZCBvcHRp b24gaXMgc3BlY2lmaWVkLg0KPj4gU29tZSBvZiB0aGVzZSBvcHRpb25zIHdpbGwgd29yayBvbiBh bGwgY3VycmVudGx5IHN1cHBvcnRlZCB2ZXJzaW9ucywNCj4+IHNvIEkgYW0gY3VyaW91cyB3aGF0 IG90aGVycyB0aGluayBhYm91dCBza2lwcGluZyBzb21lIG9mIHRoZXNlIHZlcnNpb24NCj4+IGNo ZWNrcyBhbHRvZ2V0aGVyLg0KPg0KPiBwcmVwYXJlX3ZhY3V1bV9jb21tYW5kKCkgYWxyZWFkeSBo YW5kbGVzIHRoYXQgYnkgaWdub3Jpbmcgc2lsZW50bHkNCj4gdW5zdXBwb3J0ZWQgb3B0aW9ucyAo c2VlIHRoZSBjYXNlIG9mIFNLSVBfTE9DS0VEKS4gIFNvIHdoeSBub3QgZG9pbmcgdGhlDQo+IHNh bWU/DQoNClRoZSAtLXNraXAtbG9ja2VkIG9wdGlvbiBpbiB2YWN1dW1kYiBpcyBwYXJ0IG9mIDAw MDIsIHNvIEkgZG9uJ3QgdGhpbmsNCnRoZXJlJ3MgbXVjaCBwcmVjZWRlbnQgaGVyZS4gIFdlIGRv IGN1cnJlbnRseSBmYWxsIGJhY2sgdG8gdGhlDQp1bnBhcmVudGhlc2l6ZWQgc3ludGF4IGZvciBW QUNVVU0gZm9yIHZlcnNpb25zIGJlZm9yZSA5LjAsIHNvIHRoZXJlIGlzDQpzb21lIHZlcnNpb24g aGFuZGxpbmcgYWxyZWFkeS4gIFdoYXQgZG8geW91IHRoaW5rIGFib3V0IHJlbW92aW5nDQp2ZXJz aW9uIGNoZWNrcyBmb3IgdW5zdXBwb3J0ZWQgbWFqb3IgdmVyc2lvbnM/ICBJZiB3ZSB3ZW50IHRo YXQgcm91dGUsDQp0aGVzZSBuZXcgcGF0Y2hlcyBjb3VsZCBhZGQgdmVyc2lvbiBjaGVja3Mgb25s eSBmb3Igb3B0aW9ucyB0aGF0IHdlcmUNCmFkZGVkIGluIGEgc3VwcG9ydGVkIG1ham9yIHZlcnNp b24gKGUuZy4gbXhpZF9hZ2UoKSB3YXMgYWRkZWQgaW4gOS41KS4NCkVpdGhlciB3YXksIHdlJ2xs IHN0aWxsIGhhdmUgdG8gZGVjaWRlIHdoZXRoZXIgdG8gZmFpbCBvciB0byBzaWxlbnRseQ0Kc2tp cCB0aGUgb3B0aW9uIGlmIHlvdSBkbyBzb21ldGhpbmcgbGlrZSBzcGVjaWZ5IC0tbWluLW14aWQt YWdlIGZvciBhDQo5LjQgc2VydmVyLg0KDQo+PiBJdCBkb2VzIG5vdCBzZWVtIGNsZWFyIHdoZXRo ZXIgdGhlIHVzZXIgd2FudHMgdXMgdG8gcHJvY2VzcyBteXRhYmxlDQo+PiBvbmx5IGlmIGl0IGlz IGF0IGxlYXN0IDEgR0IsIG9yIGlmIHdlIHNob3VsZCBwcm9jZXNzIG15dGFibGUgaW4NCj4+IGFk ZGl0aW9uIHRvIGFueSBvdGhlciByZWxhdGlvbnMgb3ZlciAxIEdCLiAgRWl0aGVyIHdheSwgSSB0 aGluayB0cnlpbmcNCj4+IHRvIHN1cHBvcnQgdGhlc2UgY29tYmluYXRpb25zIG9mIG9wdGlvbnMg YWRkcyBtb3JlIGNvbXBsZXhpdHkgdGhhbiBpdA0KPj4gaXMgd29ydGguDQo+DQo+IEl0IHNlZW1z IHRvIG1lIHRoYXQgYSBjb21iaW5hdGlvbiBvZiBib3RoIG9wdGlvbnMgbWVhbnMgdGhhdCB0aGUg bGlzdGVkDQo+IHRhYmxlIHNob3VsZCBiZSBwcm9jZXNzZWQgb25seSBpZiBpdHMgbWluaW11bSBz aXplIGlzIDFHQi4gIElmIG11bHRpcGxlDQo+IHRhYmxlcyBhcmUgc3BlY2lmaWVkIHdpdGggLS10 YWJsZSwgdGhlbiBvbmx5IHRob3NlIHJlYWNoaW5nIDFHQiB3b3VsZCBiZQ0KPiBwcm9jZXNzZWQu ICBTbyB0aGlzIHJlc3RyaWN0aW9uIGNhbiBnbyBhd2F5LiAgVGhlIHNhbWUgYXBwbGllcyBmb3Ig dGhlDQo+IHByb3Bvc2VkIC0tbWluLXhpZC1hZ2UgYW5kIC0tbWluLW14aWQtYWdlLg0KDQpPa2F5 LiAgVGhpcyBzaG91bGQgYmUgcHJldHR5IGVhc3kgdG8gZG8gdXNpbmcgaW5kaXZpZHVhbCBjYXRh bG9nDQpsb29rdXBzIGJlZm9yZSB3ZSBjYWxsIHByZXBhcmVfdmFjdXVtX2NvbW1hbmQoKS4gIEFs dGVybmF0aXZlbHksIEkNCmNvdWxkIGFkZCBhIGNsYXVzZSBmb3IgZWFjaCBzcGVjaWZpZWQgdGFi bGUgaW4gdGhlIGV4aXN0aW5nIHF1ZXJ5IGluDQp2YWN1dW1fb25lX2RhdGFiYXNlKCkuICBBdCB0 aGF0IHBvaW50LCBpdCBtYXkgYmUgY2xlYW5lciB0byBqdXN0IHVzZQ0KdGhhdCBjYXRhbG9nIHF1 ZXJ5IGluIGFsbCBjYXNlcyBpbnN0ZWFkIG9mIGxlYXZpbmcgcGF0aHMgd2hlcmUgdGFibGVzDQpj YW4gcmVtYWluIE5VTEwuDQoNCj4gKyAgICAgICA8cGFyYT4NCj4gKyAgICAgICAgT25seSBleGVj dXRlIHRoZSB2YWN1dW0gb3IgYW5hbHl6ZSBjb21tYW5kcyBvbiB0YWJsZXMgd2l0aCBhIG11bHRp eGFjdA0KPiArICAgICAgICBJRCBhZ2Ugb2YgYXQgbGVhc3QgPHJlcGxhY2VhYmxlDQo+IGNsYXNz PSJwYXJhbWV0ZXIiPm14aWRfYWdlPC9yZXBsYWNlYWJsZT4uDQo+ICsgICAgICAgPC9wYXJhPg0K PiBBZGRpbmcgYSBsaW5rIHRvIGV4cGxhaW4gdGhlIG11bHRpeGFjdCBidXNpbmVzcyBtYXkgYmUg aGVscGZ1bCwgc2F5DQo+IHZhY3V1bS1mb3ItbXVsdGl4YWN0LXdyYXBhcm91bmQuICBTYW1lIGNv bW1lbnQgZm9yIFhJRC4NCg0KR29vZCBpZGVhLg0KDQo+IFRoZXJlIGlzIGFuIGFyZ3VtZW50IGFi b3V0IGFsc28gYWRkaW5nIERJU0FCTEVfUEFHRV9TS0lQUElORy4NCg0KSSdsbCBhZGQgdGhpcyBp biB0aGUgbmV4dCBzZXQgb2YgcGF0Y2hlcy4gIEkgbmVlZCB0byBhZGQgdGhlDQpwYXJlbnRoZXNp emVkIHN5bnRheCBhbmQgLS1za2lwLWxvY2tlZCBmb3IgQU5BTFlaRSBpbg0KcHJlcGFyZV92YWN1 dW1fY29tbWFuZCgpLCB0b28uDQoNCk5hdGhhbg0KDQo=