Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fsVPY-0006vg-Uv for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Aug 2018 15:51:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fsVPX-0002Bl-7p for pgsql-hackers@arkaria.postgresql.org; Wed, 22 Aug 2018 15:51:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fsVPW-0002B5-T3 for pgsql-hackers@lists.postgresql.org; Wed, 22 Aug 2018 15:51:07 +0000 Received: from smtp-fw-6002.amazon.com ([52.95.49.90]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fsVPU-0004db-7m for pgsql-hackers@postgresql.org; Wed, 22 Aug 2018 15:51:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1534953064; x=1566489064; h=from:to:cc:subject:date:message-id:references: in-reply-to:mime-version; bh=rgsqvuEND4WnXFcmhqb77Maso6WztaKsujKD9XJAEwc=; b=SGIVNxg/i3QW1ZIlr7HdEF7PbG1hv3RIBXmTrXHdh4nPIKZEf3MPUSV+ mHKNg4+zW1BDZ4oE2ddv+Gg1FPuo0sqLdGY2zu2Z9k0L/aH/zQHVAfqqt V6ZpTmOQWAQo2/chPIXJsZe/39SbbHVmMSeeBYG3dEpfRr1CqFsR9qxKY 0=; X-Amazon-filename: vacuum_permission_checks.patch X-IronPort-AV: E=Sophos;i="5.53,274,1531785600"; d="scan'208";a="358681707" Received: from iad6-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-1d-474bcd9f.us-east-1.amazon.com) ([10.124.125.6]) by smtp-border-fw-out-6002.iad6.amazon.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 22 Aug 2018 15:51:00 +0000 Received: from EX13MTAUWC001.ant.amazon.com (iad55-ws-svc-p15-lb9-vlan3.iad.amazon.com [10.40.159.166]) by email-inbound-relay-1d-474bcd9f.us-east-1.amazon.com (8.14.7/8.14.7) with ESMTP id w7MFnFoJ011348 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=FAIL); Wed, 22 Aug 2018 15:49:18 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, 22 Aug 2018 15:49:16 +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, 22 Aug 2018 15:49:16 +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, 22 Aug 2018 15:49:16 +0000 From: "Bossart, Nathan" To: Michael Paquier CC: Postgres hackers , "horiguchi.kyotaro@lab.ntt.co.jp" Subject: Re: Improve behavior of concurrent ANALYZE/VACUUM Thread-Topic: Improve behavior of concurrent ANALYZE/VACUUM Thread-Index: AQHUMorqO3SZxB2DakaO1o8WveOkQ6TDhdKAgAVR8oCAAJ+cgIAAoEGAgADlmYD//8Z+gIAAi2KAgABXWYA= Date: Wed, 22 Aug 2018 15:49:16 +0000 Message-ID: References: <20180812222142.GA6097@paquier.xyz> <20180817064223.GH1693@paquier.xyz> <720DF5E4-053F-46C7-B11F-550EF2C39F6D@amazon.com> <20180821012815.GB2897@paquier.xyz> <20180822004335.GA4333@paquier.xyz> <87D61EEA-A050-4092-88F1-A0A9C9F5284A@amazon.com> <20180822053637.GC4333@paquier.xyz> In-Reply-To: <20180822053637.GC4333@paquier.xyz> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.89] Content-Type: multipart/mixed; boundary="_002_DC186201B01F4A669EC4F855A957C1F9amazoncom_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_002_DC186201B01F4A669EC4F855A957C1F9amazoncom_ Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 T24gOC8yMi8xOCwgMTI6MzcgQU0sICJNaWNoYWVsIFBhcXVpZXIiIDxtaWNoYWVsQHBhcXVpZXIu eHl6PiB3cm90ZToNCj4gT24gV2VkLCBBdWcgMjIsIDIwMTggYXQgMDI6MTc6NDRBTSArMDAwMCwg Qm9zc2FydCwgTmF0aGFuIHdyb3RlOg0KPj4gSSB0aGluayB0aGlzIGlzIGRvYWJsZSBieSBsb2Nr aW5nIHRoZSB0YWJsZSBpbiBTSEFSRSBtb2RlLiAgVGhhdCB3b24ndA0KPj4gY29uZmxpY3Qgd2l0 aCB0aGUgQWNjZXNzU2hhcmVMb2NrIHRoYXQgZXhwYW5kX3ZhY3V1bV9yZWwoKSBvYnRhaW5zLA0K Pj4gYnV0IGl0IHdpbGwgY29uZmxpY3Qgd2l0aCB0aGUgU2hhcmVVcGRhdGVFeGNsdXNpdmVMb2Nr IG9yDQo+PiBBY2Nlc3NFeGNsdXNpdmVMb2NrIHRoYXQgdmFjdXVtX3JlbCgpIHRha2VzLg0KPg0K PiBHb29kIHBvaW50LiAgU3RpbGwgaXMgdGhhdCByZWFsbHkgd29ydGggYWRkaW5nPyAgVGhpcyBp bXBsaWVzIGEgdGVzdA0KPiB3aGljaCBoYXMgYXQgbGVhc3QgdHdvIHJvbGVzLCBvbmUgc3dpdGNo aW5nIHRoZSBvd25lcnNoaXAgdG8gdGhlIG90aGVyDQo+IGFuZCBkbyBzbyBiYWNrLWFuZC1mb3J0 aC4gIEF0IGxlYXN0IHRoYXQgc2hvdWxkIGJlIG9uIGEgZGlmZmVyZW50DQo+IGlzb2xhdGlvbiBz cGVjIGZpbGUgdG8gbm90IGNvbXBsaWNhdGUgdGhlIGZpcnN0IG9uZS4NCg0KSSB0aGluayBzbywg c2luY2UgdGhpcyBpcyB0aGUgb25seSBvd25lcnNoaXAgY2hlY2tzIHdlIGRvIG9uDQppbmRpdmlk dWFsIHBhcnRpdGlvbnMuICBBbm90aGVyIHNpbXBsZSB3YXkgdG8gdGVzdCB0aGlzIHdvdWxkIGJl IHRvDQpjcmVhdGUgYSBwYXJ0aXRpb25lZCB0YWJsZSB3aXRoIGEgZGlmZmVyZW50IG93bmVyIHRo YW4gdGhlIHBhcnRpdGlvbnMNCmFuZCB0byBydW4gVkFDVVVNIGFzIHRoZSBwYXJ0aXRpb25lZCB0 YWJsZSBvd25lci4gIEluIHRoaXMgY2FzZSwgd2UNCndvdWxkIHN0aWxsIHJlbHkgb24gdGhlIGNo ZWNrcyBpbiB2YWN1dW1fcmVsKCkgYW5kIGFuYWx5emVfcmVsKCkuICBJTU8NCnRoaXMgaXMgYSBy ZWFzb24gdG8gYXZvaWQgc2tpcHBpbmcgZ2F0aGVyaW5nIHRoZSBpbmRpdmlkdWFsIHBhcnRpdGlv bnMNCmJhc2VkIHVwb24gdGhlIG93bmVyc2hpcCBvZiB0aGUgcGFydGl0aW9uZWQgdGFibGUuICBJ dCdzIHRydWUgdGhhdA0KdGhpcyB3b3VsZG4ndCBmaXggdGhlIGxvY2tpbmcgaXNzdWUgZm9yIHBh cnRpdGlvbnMsIGJ1dCB0aGUNCmFmb3JlbWVudGlvbmVkIGVkZ2UgY2FzZSBpcyBzdGlsbCBwcmVz ZW50IHdpdGggMDAwMiBhbnl3YXkuICBQbHVzLCBpdA0Kd291bGQgYWRkIGEgYml0IG1vcmUgY29u c2lzdGVuY3kgdG8gcGFydGl0aW9uIGhhbmRsaW5nIGluIFZBQ1VVTS4NCg0KSSd2ZSBhdHRhY2hl ZCBhIHBhdGNoIHRoYXQgYXBwbGllcyBvbiB0b3Agb2YgMDAwMiB0aGF0IGFkZHMgYSBzaW1wbGUN CnRlc3QgdG8gZXhlcmNpc2UgdGhlIGNoZWNrcyBpbiB2YWN1dW1fcmVsKCkgYW5kIGFuYWx5emVf cmVsKCkuDQoNCisJCS8qDQorCQkgKiBGb3IgVkFDVVVNIEFOQUxZWkUsIGJvdGggbG9ncyBjb3Vs ZCBzaG93IHVwLCBidXQganVzdCBnZW5lcmF0ZQ0KKwkJICogaW5mb3JtYXRpb24gZm9yIFZBQ1VV TSBhcyB0aGF0IHdvdWxkIGJlIHRoZSBmaXJzdCBvbmUgdG8NCisJCSAqIHByb2Nlc3MuDQorCQkg Ki8NCisJCXJldHVybjsNCg0KV2Ugc2hvdWxkIHByb2JhYmx5IHJldHVybiBmYWxzZSBoZXJlLg0K DQpOYXRoYW4NCg0K --_002_DC186201B01F4A669EC4F855A957C1F9amazoncom_ Content-Type: application/octet-stream; name="vacuum_permission_checks.patch" Content-Description: vacuum_permission_checks.patch Content-Disposition: attachment; filename="vacuum_permission_checks.patch"; size=1878; creation-date="Wed, 22 Aug 2018 15:49:16 GMT"; modification-date="Wed, 22 Aug 2018 15:49:16 GMT" Content-ID: <82549FA433BF1541BCD940AD00548E7E@amazon.com> Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdmFjdXVtLm91dCBiL3NyYy90 ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvdmFjdXVtLm91dAppbmRleCBjOWJlNzFlZjYwLi40NWU2OTU3 M2NlIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3ZhY3V1bS5vdXQKKysr IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC92YWN1dW0ub3V0CkBAIC0xMTksOSArMTE5LDIx IEBAIEFOQUxZWkUgKG5vbmV4aXN0YW50LWFyZykgZG9lc19ub3RfZXhpc3Q7CiBFUlJPUjogIHN5 bnRheCBlcnJvciBhdCBvciBuZWFyICJub25leGlzdGFudCIKIExJTkUgMTogQU5BTFlaRSAobm9u ZXhpc3RhbnQtYXJnKSBkb2VzX25vdF9leGlzdDsKICAgICAgICAgICAgICAgICAgXgorLS0gcGVy bWlzc2lvbiBjaGVja3MgaW4gdmFjdXVtX3JlbCgpIGFuZCBhbmFseXplX3JlbCgpCitDUkVBVEUg Uk9MRSB2YWNwYXJ0ZWRfb3duZXI7CitBTFRFUiBUQUJMRSB2YWNwYXJ0ZWQgT1dORVIgVE8gdmFj cGFydGVkX293bmVyOworU0VUIFJPTEUgdmFjcGFydGVkX293bmVyOworVkFDVVVNIHZhY3BhcnRl ZDsKK1dBUk5JTkc6ICBza2lwcGluZyAidmFjcGFydGVkMSIgLS0tIG9ubHkgdGFibGUgb3IgZGF0 YWJhc2Ugb3duZXIgY2FuIHZhY3V1bSBpdAorQU5BTFlaRSB2YWNwYXJ0ZWQ7CitXQVJOSU5HOiAg c2tpcHBpbmcgInZhY3BhcnRlZDEiIC0tLSBvbmx5IHRhYmxlIG9yIGRhdGFiYXNlIG93bmVyIGNh biBhbmFseXplIGl0CitWQUNVVU0gKEFOQUxZWkUpIHZhY3BhcnRlZDsKK1dBUk5JTkc6ICBza2lw cGluZyAidmFjcGFydGVkMSIgLS0tIG9ubHkgdGFibGUgb3IgZGF0YWJhc2Ugb3duZXIgY2FuIHZh Y3V1bSBpdAorUkVTRVQgUk9MRTsKIERST1AgVEFCTEUgdmFjY2x1c3RlcjsKIERST1AgVEFCTEUg dmFjdHN0OwogRFJPUCBUQUJMRSB2YWNwYXJ0ZWQ7CitEUk9QIFJPTEUgdmFjcGFydGVkX293bmVy OwogLS0gcmVsYXRpb24gb3duZXJzaGlwLCBXQVJOSU5HIGxvZ3MgZ2VuZXJhdGVkIGFzIGFsbCBh cmUgc2tpcHBlZC4KIENSRUFURSBUQUJMRSB2YWNvd25lZCAoYSBpbnQpOwogQ1JFQVRFIFJPTEUg cmVncmVzc192YWN1dW07CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC92YWN1dW0u c3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvdmFjdXVtLnNxbAppbmRleCAwZmVmZjdjNDEzLi45 ZTRkMDgxZGE5IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC92YWN1dW0uc3FsCisr KyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3ZhY3V1bS5zcWwKQEAgLTkzLDkgKzkzLDE5IEBAIEFO QUxZWkUgdmFjdHN0IChpKSwgdmFjcGFydGVkIChkb2VzX25vdF9leGlzdCk7CiBBTkFMWVpFIChW RVJCT1NFKSBkb2VzX25vdF9leGlzdDsKIEFOQUxZWkUgKG5vbmV4aXN0YW50LWFyZykgZG9lc19u b3RfZXhpc3Q7CiAKKy0tIHBlcm1pc3Npb24gY2hlY2tzIGluIHZhY3V1bV9yZWwoKSBhbmQgYW5h bHl6ZV9yZWwoKQorQ1JFQVRFIFJPTEUgdmFjcGFydGVkX293bmVyOworQUxURVIgVEFCTEUgdmFj cGFydGVkIE9XTkVSIFRPIHZhY3BhcnRlZF9vd25lcjsKK1NFVCBST0xFIHZhY3BhcnRlZF9vd25l cjsKK1ZBQ1VVTSB2YWNwYXJ0ZWQ7CitBTkFMWVpFIHZhY3BhcnRlZDsKK1ZBQ1VVTSAoQU5BTFla RSkgdmFjcGFydGVkOworUkVTRVQgUk9MRTsKKwogRFJPUCBUQUJMRSB2YWNjbHVzdGVyOwogRFJP UCBUQUJMRSB2YWN0c3Q7CiBEUk9QIFRBQkxFIHZhY3BhcnRlZDsKK0RST1AgUk9MRSB2YWNwYXJ0 ZWRfb3duZXI7CiAKIC0tIHJlbGF0aW9uIG93bmVyc2hpcCwgV0FSTklORyBsb2dzIGdlbmVyYXRl ZCBhcyBhbGwgYXJlIHNraXBwZWQuCiBDUkVBVEUgVEFCTEUgdmFjb3duZWQgKGEgaW50KTsK --_002_DC186201B01F4A669EC4F855A957C1F9amazoncom_--