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 1idFoK-00060U-EJ for pgsql-performance@arkaria.postgresql.org; Fri, 06 Dec 2019 15:46:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1idFoJ-0006mD-7b for pgsql-performance@arkaria.postgresql.org; Fri, 06 Dec 2019 15:46:27 +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 1idFoI-0006m6-R5 for pgsql-performance@lists.postgresql.org; Fri, 06 Dec 2019 15:46:26 +0000 Received: from mails1.kns.com ([199.171.180.11]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1idFoE-0007ff-M3 for pgsql-performance@postgresql.org; Fri, 06 Dec 2019 15:46:24 +0000 X-ASG-Debug-ID: 1575647179-0a96b62ac82b8720001-c4zXsc Received: from USEPRDEX1.corp.kns.com (useprdex1.corp.kns.com [10.40.10.30]) by Mails1.kns.com with ESMTP id JHMnycUBf6ZWWvEg; Fri, 06 Dec 2019 10:46:19 -0500 (EST) X-Barracuda-Envelope-From: mschanne@kns.com Received: from USEPRDEX1.corp.kns.com (10.40.10.30) by USEPRDEX1.corp.kns.com (10.40.10.30) with Microsoft SMTP Server (TLS) id 15.0.1263.5; Fri, 6 Dec 2019 10:46:16 -0500 Received: from USEPRDEX1.corp.kns.com ([fe80::8902:ecdb:4dc3:cfac]) by USEPRDEX1.corp.kns.com ([fe80::8902:ecdb:4dc3:cfac%22]) with mapi id 15.00.1263.000; Fri, 6 Dec 2019 10:46:16 -0500 From: Mike Schanne To: 'Tom Lane' CC: "'pgsql-performance@postgresql.org'" Subject: RE: autovacuum locking question Thread-Topic: autovacuum locking question X-ASG-Orig-Subj: RE: autovacuum locking question Thread-Index: AQHVq8aUgtFqZFXdQdakcThlRxUbIaetQNiA Date: Fri, 6 Dec 2019 15:46:15 +0000 Message-ID: <1f62dd52283e4aa3b5d730d546cc4c02@USEPRDEX1.corp.kns.com> References: <0871fcf35ceb4caa8a2204ca9c38e330@USEPRDEX1.corp.kns.com> <26221.1575589746@sss.pgh.pa.us> In-Reply-To: <26221.1575589746@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.40.22.174] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Barracuda-Connect: useprdex1.corp.kns.com[10.40.10.30] X-Barracuda-Start-Time: 1575647179 X-Barracuda-URL: https://Mails1.kns.com:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at kns.com X-Barracuda-Scan-Msg-Size: 3043 X-Barracuda-BRTS-Status: 1 X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=1000.0 tests=WEIRD_QUOTING X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.3.78489 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.00 WEIRD_QUOTING BODY: Weird repeated double-quotation marks List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SXMgdGhpcyB3aGF0IHlvdSBhcmUgcmVmZXJyaW5nIHRvPw0KDQotIFByZXZlbnQgVkFDVVVNIGZy b20gdHJ5aW5nIHRvIGZyZWV6ZSBhbiBvbGQgbXVsdGl4YWN0IElEIGludm9sdmluZyBhIHN0aWxs LXJ1bm5pbmcgdHJhbnNhY3Rpb24gKE5hdGhhbiBCb3NzYXJ0LCBKZXJlbXkgU2NobmVpZGVyKQ0K VGhpcyBjYXNlIHdvdWxkIGxlYWQgdG8gVkFDVVVNIGZhaWxpbmcgdW50aWwgdGhlIG9sZCB0cmFu c2FjdGlvbiB0ZXJtaW5hdGVzLg0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy9yZWxl YXNlLzkuNi4xNi8NCg0KVGhhbmtzLA0KTWlrZQ0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0t LQ0KRnJvbTogVG9tIExhbmUgW21haWx0bzp0Z2xAc3NzLnBnaC5wYS51c10NClNlbnQ6IFRodXJz ZGF5LCBEZWNlbWJlciAwNSwgMjAxOSA2OjQ5IFBNDQpUbzogTWlrZSBTY2hhbm5lDQpDYzogJ3Bn c3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3JnJw0KU3ViamVjdDogUmU6IGF1dG92YWN1dW0g bG9ja2luZyBxdWVzdGlvbg0KDQpNaWtlIFNjaGFubmUgPG1zY2hhbm5lQGtucy5jb20+IHdyaXRl czoNCj4gSSBhbSBpbnZlc3RpZ2F0aW5nIGEgcGVyZm9ybWFuY2UgcHJvYmxlbSBpbiBvdXIgYXBw bGljYXRpb24gYW5kIGFtIHNlZWluZyBzb21ldGhpbmcgdW5leHBlY3RlZCBpbiB0aGUgcG9zdGdy ZXMgbG9ncyByZWdhcmRpbmcgdGhlIGF1dG92YWN1dW0uDQoNCj4gMjAxOS0xMi0wMSAxMzowNToz OS4wMjkgVVRDLCJ3YiIsInBvc3RncmVzIiw2OTY2LCIxMjcuMC4wLjE6NTM5NzYiLDVkZGJkOTkw LjFiMzYsMTcwOTksIklOU0VSVCB3YWl0aW5nIiwyMDE5LTExLTI1IDEzOjM5OjI4IFVUQywxMi8x ODg0MjU2LDEyNjE1MDIzLExPRywwMDAwMCwicHJvY2VzcyA2OTY2IHN0aWxsIHdhaXRpbmcgZm9y IFJvd0V4Y2x1c2l2ZUxvY2sgb24gcmVsYXRpb24gMzI5Mzggb2YgZGF0YWJhc2UgMzI3NjggYWZ0 ZXIgMTAwMC4wODUgbXMiLCJQcm9jZXNzIGhvbGRpbmcgdGhlIGxvY2s6IDYwNDUuIFdhaXQgcXVl dWU6IDY5NjYuIiwsLCwsIklOU0VSVCBJTlRPIG15c2NoZW1hLm15dGFibGUgKC4uLikgVkFMVUVT ICguLi4pIFJFVFVSTklORyBwcm9jZXNzLm15dGFibGUubXl0YWJsZV9pZCIsMTMsLCIiDQo+IDIw MTktMTItMDEgMTM6MDU6MzkuNDU4IFVUQywsLDYwNDUsLDVkZTNiODAwLjE3OWQsMSwsMjAxOS0x Mi0wMSAxMjo1NDoyNCBVVEMsMTAvNDE3OTAwLDAsRVJST1IsNTcwMTQsImNhbmNlbGluZyBhdXRv dmFjdXVtIHRhc2siLCwsLCwiYXV0b21hdGljIHZhY3V1bSBvZiB0YWJsZSAiInBvc3RncmVzLm15 c2NoZW1hLm15dGFibGUiIiIsLCwsIiINCg0KPiBNeSB1bmRlcnN0YW5kaW5nIGZyb20gcmVhZGlu ZyB0aGUgZG9jdW1lbnRhdGlvbiB3YXMgdGhhdCBhIHZhY3V1bSBjYW4gcnVuIGNvbmN1cnJlbnRs eSB3aXRoIHRhYmxlIGluc2VydHMvdXBkYXRlcywgYnV0IGZyb20gcmVhZGluZyB0aGUgbG9ncyBp dCBhcHBlYXJzIHRoZXkgYXJlIGNvbmZsaWN0aW5nIG92ZXIgYSByb3cgbG9jay4gIFRoaXMgcGFy dGljdWxhciB0YWJsZSBnZXRzIHZlcnkgZnJlcXVlbnQgaW5zZXJ0cy91cGRhdGVzICgxMC0xMDAg aW5zZXJ0cyAvIHNlYykgc28gSSBhbSBjb25jZXJuZWQgdGhhdCBpZiB0aGUgYXV0b3ZhY3V1bSBp cyBjb25zdGFudGx5IGNhbmNlbGVkLCB0aGVuIHRoZSB0YWJsZSBuZXZlciBnZXRzIGNsZWFuZWQg YW5kIGl0cyBwZXJmb3JtYW5jZSB3aWxsIGNvbnRpbnVlIHRvIGRlZ3JhZGUgb3ZlciB0aW1lLiAg SXMgaXQgZXhwZWN0ZWQgZm9yIHRoZSB2YWN1dW0gdG8gYmUgY2FuY2VsZWQgYnkgYW4gaW5zZXJ0 IGluIHRoaXMgd2F5Pw0KDQpUaGUgbWFpbiBwYXJ0IG9mIGFuIGF1dG92YWN1dW0gb3BlcmF0aW9u IHNob3VsZCBnbyB0aHJvdWdoIE9LLiAgVGhlIG9ubHkgcGFydCB0aGF0IHdvdWxkIGdldCBjYW5j ZWxlZCBpbiByZXNwb25zZSB0byBzb21lYm9keSB0YWtpbmcgYSBub24tZXhjbHVzaXZlIGxvY2sg aXMgdGhlIGxhc3Qgc3RlcCwgd2hpY2ggaXMgdHJ1bmNhdGlvbiBvZiB1bnVzZWQgYmxvY2tzIGF0 IHRoZSBlbmQgb2YgdGhlIHRhYmxlOyB0aGF0IHJlcXVpcmVzIGFuIGV4Y2x1c2l2ZSBsb2NrLiAg Tm9ybWFsbHksIHNraXBwaW5nIHRoYXQgc3RlcCBpc24ndCB0ZXJyaWJseSBwcm9ibGVtYXRpYy4N Cg0KPiBXZSBhcmUgdXNpbmcgcG9zdGdyZXMgOS42LjEwLg0KDQpJSVJDLCB3ZSd2ZSBtYWRlIGlt cHJvdmVtZW50cyBpbiB0aGlzIGFyZWEgc2luY2UgOS42LCB0byBhbGxvdyBhIHBhcnRpYWwgdHJ1 bmNhdGlvbiB0byBiZSBkb25lIGlmIHNvbWVvbmUgd2FudHMgdGhlIGxvY2ssIHJhdGhlciB0aGFu IGp1c3QgZmFpbGluZyBlbnRpcmVseS4NCg0KcmVnYXJkcywgdG9tIGxhbmUNCg0KDQoNCl9fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNClRoaXMgZW1haWwgaXMgbm9uLWJpbmRpbmcs IGlzIHN1YmplY3QgdG8gY29udHJhY3QsIGFuZCBuZWl0aGVyIEt1bGlja2UgYW5kIFNvZmZhIElu ZHVzdHJpZXMsIEluYy4gbm9yIGl0cyBzdWJzaWRpYXJpZXMgKGVhY2ggYW5kIGNvbGxlY3RpdmVs eSDigJxLJlPigJ0pIHNoYWxsIGhhdmUgYW55IG9ibGlnYXRpb24gdG8geW91IHRvIGNvbnN1bW1h dGUgdGhlIHRyYW5zYWN0aW9ucyBoZXJlaW4gb3IgdG8gZW50ZXIgaW50byBhbnkgYWdyZWVtZW50 LCBvdGhlciB0aGFuIGluIGFjY29yZGFuY2Ugd2l0aCB0aGUgdGVybXMgYW5kIGNvbmRpdGlvbnMg b2YgYSBkZWZpbml0aXZlIGFncmVlbWVudCBpZiBhbmQgd2hlbiBuZWdvdGlhdGVkLCBmaW5hbGl6 ZWQgYW5kIGV4ZWN1dGVkIGJldHdlZW4gdGhlIHBhcnRpZXMuIFRoaXMgZW1haWwgYW5kIGFsbCBp dHMgY29udGVudHMgYXJlIHByb3RlY3RlZCBieSBJbnRlcm5hdGlvbmFsIGFuZCBVbml0ZWQgU3Rh dGVzIGNvcHlyaWdodCBsYXdzLiBBbnkgcmVwcm9kdWN0aW9uIG9yIHVzZSBvZiBhbGwgb3IgYW55 IHBhcnQgb2YgdGhpcyBlbWFpbCB3aXRob3V0IHRoZSBleHByZXNzIHdyaXR0ZW4gY29uc2VudCBv ZiBLJlMgaXMgcHJvaGliaXRlZC4NCg==