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 1ggwON-0004hE-OC for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Jan 2019 18:46: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 1ggwOM-0004cs-FY for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Jan 2019 18:46:22 +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 1ggwOM-0004cl-7q for pgsql-hackers@lists.postgresql.org; Tue, 08 Jan 2019 18:46:22 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1ggwOJ-0005Dz-Cj for pgsql-hackers@postgresql.org; Tue, 08 Jan 2019 18:46:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1546973179; x=1578509179; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=8Wbrqe6m1qoq03onW/g4BHeczB3b1ycjJKEgKpV9NsU=; b=D355P9qNRf8XLJ0RQv/enNS39MmLN6D47yVzKeeGqQtKKFB0qq6/GYaK mNuaErGwulcWuep/4jxXhTlTi3MxWHUcPbnYUXStZIq3GHklnzLzgpsBN Rzt2uljaT/7Od/QnzngS5pm1HjFuAHxl8LIVEEPBnCGHest/XYP3wNbUD g=; X-IronPort-AV: E=Sophos;i="5.56,253,1539648000"; d="scan'208";a="780382595" Received: from sea3-co-svc-lb6-vlan3.sea.amazon.com (HELO email-inbound-relay-2a-d0be17ee.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; 08 Jan 2019 18:46:14 +0000 Received: from EX13MTAUWC001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan2.pdx.amazon.com [10.236.137.194]) by email-inbound-relay-2a-d0be17ee.us-west-2.amazon.com (8.14.7/8.14.7) with ESMTP id x08IkDs0056206 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Tue, 8 Jan 2019 18:46:13 GMT Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWC001.ant.amazon.com (10.43.162.135) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Tue, 8 Jan 2019 18:46:13 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1367.3; Tue, 8 Jan 2019 18:46:12 +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; Tue, 8 Jan 2019 18:46:12 +0000 From: "Bossart, Nathan" To: Michael Paquier , Masahiko Sawada CC: 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//oXAAgBZvvQCABCXhgIABGu8AgACztIA= Date: Tue, 8 Jan 2019 18:46:11 +0000 Message-ID: References: <20181220020522.GM27104@paquier.xyz> <7B4ACE8E-5D81-416B-B984-17E60F7ABABA@amazon.com> <33F59F9F-78A6-4ECE-BFE0-B1E4AAF40094@amazon.com> <579F2B3A-4EA5-4032-AAD9-4AEE9219A4AB@amazon.com> <20190108020300.GH22498@paquier.xyz> In-Reply-To: <20190108020300.GH22498@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.24] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk T24gMS83LzE5LCAxOjEyIEFNLCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVyLnh5 ej4gd3JvdGU6DQo+IEkgaGF2ZSBiZWVuIGxvb2tpbmcgYXQgdGhlIHBhdGNoIHNldCwgYW5kIDAw MDEgY2FuIGFjdHVhbGx5IGhhcHBlbg0KPiBvbmx5IG9uY2UgMDAwNSBpcyBhcHBsaWVkIGJlY2F1 c2UgdGhpcyBtb2RpZmllcyB0aGUgcXVlcnkgZG9pbmcgb24NCj4gSEVBRCBhIGZ1bGwgc2NhbiBv ZiBwZ19jbGFzcyB3aGljaCB3b3VsZCBpbmNsdWRlIGF0IGxlYXN0IGNhdGFsb2cNCj4gdGFibGVz IHNvIGl0IGNhbiBuZXZlciBiZSBlbXB0eS4gIEZvciB0aGlzIHJlYXNvbiBpdCBzZWVtcyB0byBt ZSB0aGF0DQo+IDAwMDEgYW5kIDAwMDQgc2hvdWxkIGJlIG1lcmdlZCB0b2dldGhlciBhcyBjb21t b24gcmVmYWN0b3JpbmcsIG1ha2luZw0KPiBzdXJlIG9uIHRoZSB3YXkgdGhhdCBhbGwgcmVsYXRp b25zIGV4aXN0IGJlZm9yZSBwcm9jZXNzaW5nIGFueXRoaW5nLg0KPiBBcyAwMDA1IGFuZCAwMDA2 IGNoYW5nZSBzaW1pbGFyIHBvcnRpb25zIG9mIHRoZSBjb2RlLCB3ZSBjb3VsZCBhbHNvDQo+IG1l cmdlIHRoZXNlIHRvZ2V0aGVyIGluIGEgc2Vjb25kIHBhdGNoIGludHJvZHVjaW5nIHRoZSBuZXcg b3B0aW9ucy4NCj4gS2VlcGluZyAwMDAxLCAwMDA0LCAwMDA1IGFuZCAwMDA2IHNlcGFyYXRlZCBl YXNlcyB0aGUgcmV2aWV3LCBidXQgSQ0KPiB3b3VsZCBsaWtlbHkgbWVyZ2UgdGhpbmdzIHdoZW4g dGhleSBtYWtlIHNlbnNlIHRvZ2V0aGVyIHRvIHJlZHVjZQ0KPiBkaWZmIGNodW5rcy4NCg0KVGhh bmtzIGZvciByZXZpZXdpbmcuICBTdXJlLCBJIGNhbiBtZXJnZSB0aGVzZSB0b2dldGhlciBzbyB0 aGF0IGl0J3MNCmp1c3QgMiBwYXRjaGVzLg0KDQo+IDAwMDIgcmVtb3ZlcyBzb21lIGNhcmVmdWxs eS13cml0dGVuIHF1ZXJ5IGdlbmVyYXRpb24sIHNvIGFzIGl0IGlzDQo+IG5ldmVyIHBvc3NpYmxl IHRvIGdlbmVyYXRlIHNvbWV0aGluZyBsaWtlIEFOQUxZWkUgRlVMTC4gIEhFQUQgc3BsaXRzDQo+ IEFOQUxZWkUgYW5kIFZBQ1VVTSBjbGVhcmx5LCBidXQgMDAwMiBtZXJnZXMgdGhlbSB0b2dldGhl ciBzbyBhcw0KPiBjYXJlbGVzcyBjb2RpbmcgaW4gdmFjdXVtZGIuYyBtYWtlcyBpdCBlYXNpZXIg dG8gZ2VuZXJhdGUgY29tbWFuZA0KPiBzdHJpbmdzIHdoaWNoIHdvdWxkIGZhaWwgaW4gdGhlIGJh Y2tlbmQgcmVseWluZyBvbiB0aGUgb3B0aW9uIGNoZWNrcw0KPiB0byBtYWtlIHN1cmUgdGhhdCBm b3IgZXhhbXBsZSBjb21iaW5pbmcgLS1mdWxsIGFuZCAtLWFuYWx5emUtb25seQ0KPiBuZXZlciBo YXBwZW5zLiAgSW50cm9kdWNpbmcgMDAwMiBpcyBtYWlubHkgaGVyZSBmb3IgMDAwMywgc28gbGV0 J3MNCj4gbWVyZ2UgdGhlbSB0b2dldGhlci4NCg0KTWFrZXMgc2Vuc2UuICBJIHdhcyB0cnlpbmcg dG8gc2ltcGxpZnkgdGhpcyBjb2RlIGEgYml0LCBidXQgSSBhZ3JlZQ0Kd2l0aCB5b3VyIHBvaW50 IGFib3V0IHJlbHlpbmcgb24gdGhlIG9wdGlvbiBjaGVja3MuDQoNCj4gRnJvbSBwYXRjaCAwMDA0 Og0KPiArICAgICAgIGV4ZWN1dGVDb21tYW5kKGNvbm4sICJSRVNFVCBzZWFyY2hfcGF0aDsiLCBw cm9nbmFtZSwgZWNobyk7DQo+ICsgICAgICAgcmVzID0gZXhlY3V0ZVF1ZXJ5KGNvbm4sIGNhdGFs b2dfcXVlcnkuZGF0YSwgcHJvZ25hbWUsIGVjaG8pOw0KPiArICAgICAgIHRlcm1QUUV4cEJ1ZmZl cigmY2F0YWxvZ19xdWVyeSk7DQo+ICsgICAgICAgUFFjbGVhcihleGVjdXRlUXVlcnkoY29ubiwg QUxXQVlTX1NFQ1VSRV9TRUFSQ0hfUEFUSF9TUUwsDQo+ICsgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgcHJvZ25hbWUsIGVjaG8pKTsNCj4gV2Ugc2hvdWxkIHJlYWxseSBhdm9pZCB0aGF0 LiAgVGhlcmUgYXJlIG90aGVyIHRoaW5ncyBsaWtlIGNhc3RzIHdoaWNoDQo+IHRlbmQgdG8gYmUg Zm9yZ290dGVuLCBhbmQgaWYgdGhlIGNhdGFsb2cgbG9va3VwIHF1ZXJ5IGdldHMgbW9yZQ0KPiBj b21wbGljYXRlZCwgSSBmZWVsIHRoYXQgdGhpcyB3b3VsZCBhZ2FpbiBiZSBmb3Jnb3R0ZW4sIHJl aW50cm9kdWNpbmcNCj4gdGhlIGlzc3VlcyB0aGF0IEFMV0FZU19TRUNVUkVfU0VBUkNIX1BBVEhf U1FMIGlzIGhlcmUgdG8gZml4Lg0KDQpUaGlzIHdhcyBkb25lIGluIG9yZGVyIHRvIG1haW50YWlu IHRoZSBjdXJyZW50IGJlaGF2aW9yIHRoYXQNCmFwcGVuZFF1YWxpZmllZFJlbGF0aW9uKCkgZ2l2 ZXMgdXMuICBJIGZvdW5kIHRoYXQgc2tpcHBpbmcgdGhlDQpzZWFyY2hfcGF0aCBoYW5kbGluZyBo ZXJlIGZvcmNlZCB1cyB0byBzcGVjaWZ5IHRoZSBzY2hlbWEgaW4gdGhlDQphcmd1bWVudCBmb3Ig LS10YWJsZSBpbiBtb3N0IGNhc2VzLiAgQXQgdGhlIHZlcnkgbGVhc3QsIEkgY291bGQgYWRkIGEN CmNvbW1lbnQgaGVyZSB0byBoaWdobGlnaHQgdGhlIGltcG9ydGFuY2Ugb2YgZnVsbHkgcXVhbGlm eWluZw0KZXZlcnl0aGluZyBpbiB0aGUgY2F0YWxvZyBxdWVyeS4gIFdoYXQgZG8geW91IHRoaW5r Pw0KDQo+IEkgaGF2ZSBwdXQgbXkgaGFuZHMgaW50byB3aGF0IHlvdSBzZW50LCBhbmQgd29ya2Vk IG9uIHB1dHRpbmcNCj4gMDAwMi8wMDAzIGZpcnN0IGludG8gc2hhcGUsIGZpbmlzaGluZyB3aXRo IHRoZSBhdHRhY2hlZC4gIEkgaGF2ZQ0KPiBzaW1wbGlmaWVkIHRoZSBxdWVyeSBjb25zdHJ1Y3Rp b24gYSBiaXQsIG1ha2luZyBpdCBJTU8gZWFzaWVyIHRvIHJlYWQNCj4gYW5kIHRvIGFkZCBuZXcg b3B0aW9ucywgd2l0aCBjb21tZW50cyBkb2N1bWVudGluZyB3aGF0J3Mgc3VwcG9ydGVkDQo+IGFj cm9zcyB2ZXJzaW9ucy4gIEkgaGF2ZSBhbHNvIGFkZGVkIGEgcmVncmVzc2lvbiB0ZXN0IGZvcg0K PiAtLWFuYWx5emUtb25seSAtLXNraXAtbG9ja2VkLiAgVGhlbiBJIGhhdmUgZG9uZSBzb21lIGVk aXQgb2YgdGhlIGRvY3MuDQo+IFdoYXQgZG8geW91IHRoaW5rIGZvciB0aGlzIHBvcnRpb24/DQoN Ckxvb2tzIGdvb2QgdG8gbWUsIGV4Y2VwdCBmb3Igb25lIHNtYWxsIHRoaW5nIGluIHRoZSBkb2N1 bWVudGF0aW9uOg0KDQorICAgICAgIDxwYXJhPg0KKyAgICAgICAgRGlzYWJsZSBhbGwgcGFnZS1z a2lwcGluZyBiZWhhdmlvciBkdXJpbmcgcHJvY2Vzc2luZyBiYXNlZCBvbg0KKyAgICAgICAgdGhl IHZpc2liaWxpdHkgbWFwLCBzaW1pbGFybHkgdG8gdGhlIG9wdGlvbg0KKyAgICAgICAgPGxpdGVy YWw+RElTQUJMRV9QQUdFX1NLSVBQSU5HPC9saXRlcmFsPiBmb3IgPGNvbW1hbmQ+VkFDVVVNPC9j b21tYW5kPi4NCisgICAgICAgPC9wYXJhPg0KDQpJIHRoaW5rIHRoZSAic2ltaWxhcmx5IHRvIHRo ZSBvcHRpb24iIHBhcnQgaXMgc2xpZ2h0bHkgbWlzbGVhZGluZy4NCkl0J3Mgbm90IGp1c3Qgc2lt aWxhciwgaXQgX2lzXyB1c2luZyB0aGF0IG9wdGlvbiBpbiB0aGUgZ2VuZXJhdGVkDQpjb21tYW5k cy4gIFBlcmhhcHMgd2UgY291bGQgcG9pbnQgdG8gdGhlIFZBQ1VVTSBkb2N1bWVudGF0aW9uIGZv ciBtb3JlDQppbmZvcm1hdGlvbiBhYm91dCB0aGlzIG9uZS4NCg0KT24gMS83LzE5LCA4OjAzIFBN LCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVyLnh5ej4gd3JvdGU6DQo+IE9uIE1v biwgSmFuIDA3LCAyMDE5IGF0IDA2OjEwOjIxUE0gKzA5MDAsIE1hc2FoaWtvIFNhd2FkYSB3cm90 ZToNCj4+IDAwMDIgYW5kIDAwMDMgYXJlIG1lcmdlZCBhbmQgcG9zdGVkIGJ5IE1pY2hhZWwtc2Fu IGFuZCBpdCBsb29rcyBnb29kDQo+PiB0byBtZSwgc28gSSd2ZSBsb29rZWQgYXQgdGhlIDAwMDEs IDAwMDQsIDAwMDUgYW5kIDAwMDYgcGF0Y2hlcy4gSGVyZQ0KPj4gaXMgYSBmZXcgcmV2aWV3IGNv bW1lbnRzLg0KPg0KPiBJIGhhdmUgZG9uZSBhbm90aGVyIHJvdW5kIG9uIDAwMDIvMDAwMyAoUFFm aW5pc2ggd2FzIGxhY2tpbmcgYWZ0ZXINCj4gZXJyb3ItaW5nIG9uIGluY29tcGF0aWJsZSBvcHRp b25zKSBhbmQgY29tbWl0dGVkIHRoZSB0aGluZy4NCg0KVGhhbmtzIQ0KDQo+PiBFdmVuIGlmIGFs bCB0YWJsZXMgYXJlIGZpbHRlcmVkIGJ5IC0tbWluLXJlbGF0aW9uLXNpemUsIG1pbi1teGlkLWFn ZQ0KPj4gb3IgbWluLXhpZC1hZ2UgdGhlIGZvbGxvd2luZyBtZXNzYWdlIGFwcGVhcmVkLg0KPj4g DQo+PiAkIHZhY3V1bWRiIC0tdmVyYm9zZSAtLW1pbi1yZWxhdGlvbi1zaXplIDEwMDAwMDAgcG9z dGdyZXMNCj4+IHZhY3V1bWRiOiB2YWN1dW1pbmcgZGF0YWJhc2UgInBvc3RncmVzIg0KPj4gDQo+ PiBTaW5jZSBubyB0YWJsZXMgYXJlIHByb2Nlc3NlZCBpbiB0aGlzIGNhc2UgaXNuJ3QgaXMgYmV0 dGVyIG5vdCB0bw0KPj4gb3V0cHV0IHRoaXMgbWVzc2FnZSBieSBtb3ZpbmcgdGhlIG1lc3NhZ2Ug YWZ0ZXIgY2hlY2tpbmcgaWYgbnR1cCA9PQ0KPj4gMD8NCj4NCj4gSG1tLiAgTXkgdGFrZSBvbiB0 aGlzIG9uZSBpcyB0aGF0IHdlIGF0dGVtcHQgdG8gdmFjdXVtIHJlbGF0aW9ucyBvbg0KPiB0aGlz IGRhdGFiYXNlLCBidXQgdGhpcyBtYXkgZmluaXNoIGJ5IGRvaW5nIG5vdGhpbmcuICBQcmludGlu ZyB0aGlzDQo+IG1lc3NhZ2UgaXMgc3RpbGwgaW1wb3J0YW50IHRvIGxldCB0aGUgdXNlciBrbm93 IHRoYXQgYW4gYXR0ZW1wdCB3YXMNCj4gZG9uZSBzbyBJIHdvdWxkIGtlZXAgdGhlIG1lc3NhZ2Uu DQoNCisxIGZvciBrZWVwaW5nIHRoZSBtZXNzYWdlLg0KDQo+PiBZb3UgdXNlIHBnX3RvdGFsX3Jl bGF0aW9uX3NpemUoKSB0byBjaGVjayB0aGUgcmVsYXRpb24gc2l6ZSBidXQgaXQNCj4+IG1pZ2h0 IGJlIGJldHRlciB0byB1c2UgcGdfcmVsYXRpb25fc2l6ZSgpIGluc3RlYWQuIFRoZQ0KPj4gcGdf dG90YWxfcmVsYXRpb25fc2l6ZSgpIGluY2x1ZGVzIHRoZSBhbGwgaW5kZXggc2l6ZSBidXQgSSB0 aGluayBpdCdzDQo+PiBjb21tb24gYmFzZWQgb24gbXkgZXhwZXJpZW5jZSB0aGF0IHdlIGNoZWNr IG9ubHkgdGhlIHRhYmxlIHNpemUNCj4+IChpbmNsdWRpbmcgdG9hc3QgdGFibGUpIHRvIGRvIHZh Y3V1bSBpdCBvciBub3QuDQo+DQo+IFllcywgSSBhbSBhbHNvIG5vdCBjb21wbGV0ZWx5IHN1cmUg aWYgdGhlIHdheSB0aGluZ3MgYXJlIGRlZmluZWQgaW4NCj4gdGhlIHBhdGNoIGFyZSBjb21wbGV0 ZWx5IHdoYXQgd2UgYXJlIGxvb2tpbmcgZm9yLiAgU3RpbGwsIEkgaGF2ZSBzZWVuDQo+IGFzIHdl bGwgcGVvcGxlIGNvbXBsYWluIGFib3V0IHRoZSB0b3RhbCBhbW91bnQgb2Ygc3BhY2UgYSB0YWJs ZSBpcw0KPiBwaHlzaWNhbGx5IHRha2luZyBvbiBkaXNrLCBpbmNsdWRpbmcgaXRzIGluZGV4ZXMu ICBTbyBmcm9tIHRoZSB1c2VyDQo+IGV4cGVyaWVuY2UgdGhlIGRpcmVjdGlvbiB0YWtlbiBieSB0 aGUgcGF0Y2ggbWFrZXMgc2Vuc2UsIGFzIG11Y2ggYXMNCj4gZG9lcyB0aGUgYXJndW1lbnQgeW91 IGRvLg0KDQpHb29kIHBvaW50LiAgSSB0aGluayBhbGxvd2luZyBtdWx0aXBsZSBkaWZmZXJlbnQg cmVsYXRpb24gc2l6ZSBvcHRpb25zDQpoZXJlIHdvdWxkIGJlIGNvbmZ1c2luZywgdG9vIChlLmcu IC0tbWluLXJlbGF0aW9uLXNpemUgdmVyc3VzDQotLW1pbi10b3RhbC1yZWxhdGlvbi1zaXplKS4g IElNTyBwZ190b3RhbF9yZWxhdGlvbl9zaXplKCkgaXMgdGhlIHdheQ0KdG8gZ28gaGVyZSwgYXMg d2UnbGwgbW9zdCBsaWtlbHkgbmVlZCB0byBwcm9jZXNzIHRoZSBpbmRleGVzIGFuZCBUT0FTVA0K dGFibGVzLCB0b28uICBJZi93aGVuIHRoZXJlIGlzIGEgRElTQUJMRV9JTkRFWF9DTEVBTlVQIG9w dGlvbiBmb3INClZBQ1VVTSwgd2UnZCB0aGVuIHdhbnQgdG8gdXNlIHBnX3RhYmxlX3NpemUoKSB3 aGVuIC0tbWluLXJlbGF0aW9uLXNpemUNCmFuZCAtLWRpc2FibGUtaW5kZXgtY2xlYW51cCBhcmUg dXNlZCB0b2dldGhlciBpbiB2YWN1dW1kYi4gIFRob3VnaHRzPw0KDQpJJ3ZlIHJlYWxpemVkIHRo YXQgSSBmb3Jnb3QgdG8gYWRkIGxpbmtzIHRvIHRoZSBYSUQvTVhJRCB3cmFwYXJvdW5kDQpkb2N1 bWVudGF0aW9uIGxpa2UgeW91IHN1Z2dlc3RlZCBhIHdoaWxlIGJhY2suICBJJ2xsIG1ha2Ugc3Vy ZSB0aGF0DQpnZXRzIGluY2x1ZGVkIGluIHRoZSBuZXh0IHBhdGNoIHNldCwgdG9vLg0KDQpOYXRo YW4NCg0K