RE: autovacuum locking question
Mike Schanne <[email protected]> Thu, 5 Dec 2019 23:18:12 +0000
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
--_000_d5fca64e56a64011afe41a2a44726bdaUSEPRDEX1corpknscom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SW4gdGhpcyBwYXJ0aWN1bGFyIGNhc2UgYXV0b3ZhY3V1bV9jb3VudCBpcyAwLiAgbl9saXZlX3R1 cCBpcyA2NTksNjMxIGFuZCBuX2RlYWRfdHVwIGlzIDMsNDAwLDM0Ny4NCg0KV2UgYXJlIHVzaW5n IHRoZSBkZWZhdWx0IHZhY3V1bSBwYXJhbWV0ZXJzLg0KDQpGcm9tOiBNaWNoYWVsIExld2lzIFtt YWlsdG86bWxld2lzQGVudHJhdGEuY29tXQ0KU2VudDogVGh1cnNkYXksIERlY2VtYmVyIDA1LCAy MDE5IDU6NDkgUE0NClRvOiBNaWtlIFNjaGFubmUNCkNjOiBwZ3NxbC1wZXJmb3JtYW5jZUBwb3N0 Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IGF1dG92YWN1dW0gbG9ja2luZyBxdWVzdGlvbg0KDQpP biBUaHUsIERlYyA1LCAyMDE5IGF0IDM6MjYgUE0gTWlrZSBTY2hhbm5lIDxtc2NoYW5uZUBrbnMu Y29tPG1haWx0bzptc2NoYW5uZUBrbnMuY29tPj4gd3JvdGU6DQpJIGFtIGNvbmNlcm5lZCB0aGF0 IGlmIHRoZSBhdXRvdmFjdXVtIGlzIGNvbnN0YW50bHkgY2FuY2VsZWQsIHRoZW4gdGhlIHRhYmxl IG5ldmVyIGdldHMgY2xlYW5lZCBhbmQgaXRzIHBlcmZvcm1hbmNlIHdpbGwgY29udGludWUgdG8g ZGVncmFkZSBvdmVyIHRpbWUuICBJcyBpdCBleHBlY3RlZCBmb3IgdGhlIHZhY3V1bSB0byBiZSBj YW5jZWxlZCBieSBhbiBpbnNlcnQgaW4gdGhpcyB3YXk/DQoNCldlIGFyZSB1c2luZyBwb3N0Z3Jl cyA5LjYuMTAuDQoNCkhhdmUgeW91IGNoZWNrZWQgd2hlbiB0aGUgdGFibGUgd2FzIGxhc3QgYXV0 b3ZhY3V1bWVkIGluIHBnX3N0YXRfdXNlcl90YWJsZXM/IElmIHRoZSBhdXRvdmFjdXVtIGNvdW50 IGlzIGhpZ2ggYW5kIHRpbWVzdGFtcCBvZiBsYXN0IHJ1biBpcyByZWxhdGl2ZWx5IGN1cnJlbnQs IHRoZW4gbm8gcmVhc29uIGZvciBjb25jZXJuIGFzIGZhciBhcyBJIGNhbiBmaWd1cmUuDQoNCkhh dmUgeW91IGFscmVhZHkgY29uZmlndXJlZCAobm9uLWRlZmF1bHQgdmFsdWVzKSBmb3IgYXV0b3Zh Y3V1bSBvcHRpb25zIGZvciB5b3VyIHN5c3RlbSBvciB0aGlzIHRhYmxlPw0KDQpfX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXw0KDQpUaGlzIGVtYWlsIGlzIG5vbi1iaW5kaW5nLCBpcyBz dWJqZWN0IHRvIGNvbnRyYWN0LCBhbmQgbmVpdGhlciBLdWxpY2tlIGFuZCBTb2ZmYSBJbmR1c3Ry aWVzLCBJbmMuIG5vciBpdHMgc3Vic2lkaWFyaWVzIChlYWNoIGFuZCBjb2xsZWN0aXZlbHkg4oCc SyZT4oCdKSBzaGFsbCBoYXZlIGFueSBvYmxpZ2F0aW9uIHRvIHlvdSB0byBjb25zdW1tYXRlIHRo ZSB0cmFuc2FjdGlvbnMgaGVyZWluIG9yIHRvIGVudGVyIGludG8gYW55IGFncmVlbWVudCwgb3Ro ZXIgdGhhbiBpbiBhY2NvcmRhbmNlIHdpdGggdGhlIHRlcm1zIGFuZCBjb25kaXRpb25zIG9mIGEg ZGVmaW5pdGl2ZSBhZ3JlZW1lbnQgaWYgYW5kIHdoZW4gbmVnb3RpYXRlZCwgZmluYWxpemVkIGFu ZCBleGVjdXRlZCBiZXR3ZWVuIHRoZSBwYXJ0aWVzLiBUaGlzIGVtYWlsIGFuZCBhbGwgaXRzIGNv bnRlbnRzIGFyZSBwcm90ZWN0ZWQgYnkgSW50ZXJuYXRpb25hbCBhbmQgVW5pdGVkIFN0YXRlcyBj b3B5cmlnaHQgbGF3cy4gQW55IHJlcHJvZHVjdGlvbiBvciB1c2Ugb2YgYWxsIG9yIGFueSBwYXJ0 IG9mIHRoaXMgZW1haWwgd2l0aG91dCB0aGUgZXhwcmVzcyB3cml0dGVuIGNvbnNlbnQgb2YgSyZT IGlzIHByb2hpYml0ZWQuDQo= --_000_d5fca64e56a64011afe41a2a44726bdaUSEPRDEX1corpknscom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjEyLjBwdDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2VyaWYi O30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0K CWNvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNw YW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9y OnB1cnBsZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCnNwYW4uRW1haWxTdHlsZTE3 DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJp Iiwic2Fucy1zZXJpZiI7DQoJY29sb3I6IzFGNDk3RDt9DQouTXNvQ2hwRGVmYXVsdA0KCXttc28t c3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsInNhbnMtc2Vy aWYiO30NCkBwYWdlIFdvcmRTZWN0aW9uMQ0KCXtzaXplOjguNWluIDExLjBpbjsNCgltYXJnaW46 MS4waW4gMS4waW4gMS4waW4gMS4waW47fQ0KZGl2LldvcmRTZWN0aW9uMQ0KCXtwYWdlOldvcmRT ZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVk ZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0t PjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0K PG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+PC94bWw+ PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0iYmx1ZSIgdmxp bms9InB1cnBsZSI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2Fs aWJyaSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOiMxRjQ5N0QiPkluIHRoaXMg cGFydGljdWxhciBjYXNlIGF1dG92YWN1dW1fY291bnQgaXMgMC4mbmJzcDsgbl9saXZlX3R1cCBp cyA2NTksNjMxIGFuZCBuX2RlYWRfdHVwIGlzIDMsNDAwLDM0Ny48bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29s b3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2Fs aWJyaSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOiMxRjQ5N0QiPldlIGFyZSB1 c2luZyB0aGUgZGVmYXVsdCB2YWN1dW0gcGFyYW1ldGVycy48bzpwPjwvbzpwPjwvc3Bhbj48L3A+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtmb250 LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6 IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PGI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2Fs aWJyaSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7Ij5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4g c3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90Oywm cXVvdDtzYW5zLXNlcmlmJnF1b3Q7Ij4gTWljaGFlbCBMZXdpcyBbbWFpbHRvOm1sZXdpc0BlbnRy YXRhLmNvbV0NCjxicj4NCjxiPlNlbnQ6PC9iPiBUaHVyc2RheSwgRGVjZW1iZXIgMDUsIDIwMTkg NTo0OSBQTTxicj4NCjxiPlRvOjwvYj4gTWlrZSBTY2hhbm5lPGJyPg0KPGI+Q2M6PC9iPiBwZ3Nx bC1wZXJmb3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZzxicj4NCjxiPlN1YmplY3Q6PC9iPiBSZTogYXV0 b3ZhY3V1bSBsb2NraW5nIHF1ZXN0aW9uPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8ZGl2Pg0KPGRpdj4NCjxwIGNsYXNz PSJNc29Ob3JtYWwiPk9uIFRodSwgRGVjIDUsIDIwMTkgYXQgMzoyNiBQTSBNaWtlIFNjaGFubmUg Jmx0OzxhIGhyZWY9Im1haWx0bzptc2NoYW5uZUBrbnMuY29tIj5tc2NoYW5uZUBrbnMuY29tPC9h PiZndDsgd3JvdGU6PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8YmxvY2txdW90ZSBz dHlsZT0iYm9yZGVyOm5vbmU7Ym9yZGVyLWxlZnQ6c29saWQgI0NDQ0NDQyAxLjBwdDtwYWRkaW5n OjBpbiAwaW4gMGluIDYuMHB0O21hcmdpbi1sZWZ0OjQuOHB0O21hcmdpbi1yaWdodDowaW4iPg0K PGRpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibXNvLW1hcmdpbi10b3At YWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1dG8iPkkgYW0gY29uY2VybmVkIHRoYXQg aWYgdGhlIGF1dG92YWN1dW0gaXMgY29uc3RhbnRseSBjYW5jZWxlZCwgdGhlbiB0aGUgdGFibGUg bmV2ZXIgZ2V0cyBjbGVhbmVkIGFuZCBpdHMgcGVyZm9ybWFuY2Ugd2lsbCBjb250aW51ZSB0byBk ZWdyYWRlIG92ZXIgdGltZS4mbmJzcDsgSXMgaXQgZXhwZWN0ZWQgZm9yIHRoZSB2YWN1dW0NCiB0 byBiZSBjYW5jZWxlZCBieSBhbiBpbnNlcnQgaW4gdGhpcyB3YXk/PG86cD48L286cD48L3A+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1h cmdpbi1ib3R0b20tYWx0OmF1dG8iPiZuYnNwOzxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1z b05vcm1hbCIgc3R5bGU9Im1zby1tYXJnaW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9t LWFsdDphdXRvIj5XZSBhcmUgdXNpbmcgcG9zdGdyZXMgOS42LjEwLjxvOnA+PC9vOnA+PC9wPg0K PC9kaXY+DQo8L2Rpdj4NCjwvYmxvY2txdW90ZT4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPkhhdmUgeW91IGNoZWNrZWQgd2hlbiB0aGUgdGFibGUgd2FzIGxhc3QgYXV0b3ZhY3V1bWVk IGluIHBnX3N0YXRfdXNlcl90YWJsZXM/IElmIHRoZSBhdXRvdmFjdXVtIGNvdW50IGlzIGhpZ2gg YW5kIHRpbWVzdGFtcCBvZiBsYXN0IHJ1biBpcyByZWxhdGl2ZWx5IGN1cnJlbnQsIHRoZW4gbm8g cmVhc29uIGZvciBjb25jZXJuIGFzIGZhciBhcyBJIGNhbiBmaWd1cmUuPG86cD48L286cD48L3A+ DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwv cD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhhdmUgeW91IGFscmVhZHkg Y29uZmlndXJlZCAobm9uLWRlZmF1bHQgdmFsdWVzKSBmb3IgYXV0b3ZhY3V1bSBvcHRpb25zIGZv ciB5b3VyIHN5c3RlbSBvciB0aGlzIHRhYmxlPzxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8L2Rp dj4NCjwvZGl2Pg0KPC9kaXY+DQo8YnI+DQo8aHI+DQo8Zm9udCBmYWNlPSJBcmlhbCIgY29sb3I9 IkJsYWNrIiBzaXplPSIyIj48YnI+DQpUaGlzIGVtYWlsIGlzIG5vbi1iaW5kaW5nLCBpcyBzdWJq ZWN0IHRvIGNvbnRyYWN0LCBhbmQgbmVpdGhlciBLdWxpY2tlIGFuZCBTb2ZmYSBJbmR1c3RyaWVz LCBJbmMuIG5vciBpdHMgc3Vic2lkaWFyaWVzIChlYWNoIGFuZCBjb2xsZWN0aXZlbHkg4oCcSyZh bXA7U+KAnSkgc2hhbGwgaGF2ZSBhbnkgb2JsaWdhdGlvbiB0byB5b3UgdG8gY29uc3VtbWF0ZSB0 aGUgdHJhbnNhY3Rpb25zIGhlcmVpbiBvciB0byBlbnRlciBpbnRvIGFueSBhZ3JlZW1lbnQsIG90 aGVyDQogdGhhbiBpbiBhY2NvcmRhbmNlIHdpdGggdGhlIHRlcm1zIGFuZCBjb25kaXRpb25zIG9m IGEgZGVmaW5pdGl2ZSBhZ3JlZW1lbnQgaWYgYW5kIHdoZW4gbmVnb3RpYXRlZCwgZmluYWxpemVk IGFuZCBleGVjdXRlZCBiZXR3ZWVuIHRoZSBwYXJ0aWVzLiBUaGlzIGVtYWlsIGFuZCBhbGwgaXRz IGNvbnRlbnRzIGFyZSBwcm90ZWN0ZWQgYnkgSW50ZXJuYXRpb25hbCBhbmQgVW5pdGVkIFN0YXRl cyBjb3B5cmlnaHQgbGF3cy4gQW55IHJlcHJvZHVjdGlvbg0KIG9yIHVzZSBvZiBhbGwgb3IgYW55 IHBhcnQgb2YgdGhpcyBlbWFpbCB3aXRob3V0IHRoZSBleHByZXNzIHdyaXR0ZW4gY29uc2VudCBv ZiBLJmFtcDtTIGlzIHByb2hpYml0ZWQuPGJyPg0KPC9mb250Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_d5fca64e56a64011afe41a2a44726bdaUSEPRDEX1corpknscom_--