RE: autovacuum locking question
Mike Schanne <[email protected]> Fri, 6 Dec 2019 15:46:15 +0000
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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==