Обсуждение: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?
BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?
От
digoal@126.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM3OApMb2dnZWQgYnk6ICAg ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjYuMApPcGVyYXRpbmcg c3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAgICAg CgoNCg0Kd2hlbiBpIHVzZSBwb3N0Z3Jlc3FsIDkuNi4wIGZvciBwcmltYXJ5 LXN0YW5kYnksIGkgZHJvcCBhIHNjaGVtYSBvbiBwcmltYXJ5LApidXQgaXQn cyBhcHBseSB2ZXJ5IHNsb3cgb24gc3RhbmRieS4gDQogIA0KdGhlIHdhbCBz ZW5kIHZlcnkgZmFzdCwgYnV0IGFwcGx5IHZlcnkgc2xvdywgaSB0aGluayB0 aGUgc3lzY2FsbCBtb3JlIHRoYW4KaXQgb24gcHJpbWFyeT8gDQoNCnRoaXMg aXMgbXkgdGVzdDoNCg0Kb24gcHJpbWFyeSAgDQpgYGANCg0KY3JlYXRlIHRh YmxlIHRlc3QoDQpjMCBzZXJpYWwgIHVuaXF1ZSAgY2hlY2soYzA+MCksIA0K YzEgc2VyaWFsICB1bmlxdWUgIGNoZWNrKGMxPjApLCANCmMyIHNlcmlhbCAg dW5pcXVlICBjaGVjayhjMj4wKSwNCmMzIHNlcmlhbCAgdW5pcXVlICBjaGVj ayhjMz4wKSwgDQpjNCBzZXJpYWwgIHVuaXF1ZSAgY2hlY2soYzQ+MCksDQpj NSBzZXJpYWwgIHVuaXF1ZSAgY2hlY2soYzU+MCksIA0KYzYgc2VyaWFsICB1 bmlxdWUgIGNoZWNrKGM2PjApLA0KYzcgc2VyaWFsICB1bmlxdWUgIGNoZWNr KGM3PjApLCANCmM4IHNlcmlhbCAgdW5pcXVlICBjaGVjayhjOD4wKSwNCmM5 IHNlcmlhbCAgdW5pcXVlICBjaGVjayhjOT4wKSwgDQpjMTAgc2VyaWFsIHVu aXF1ZSAgIGNoZWNrKGMxMD4wKSwgDQpjMTEgc2VyaWFsIHVuaXF1ZSAgIGNo ZWNrKGMxMT4wKSwgDQpjMTIgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGMxMj4w KSwNCmMxMyBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzEzPjApLCANCmMxNCBz ZXJpYWwgdW5pcXVlICAgY2hlY2soYzE0PjApLA0KYzE1IHNlcmlhbCB1bmlx dWUgICBjaGVjayhjMTU+MCksIA0KYzE2IHNlcmlhbCB1bmlxdWUgICBjaGVj ayhjMTY+MCksDQpjMTcgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGMxNz4wKSwg DQpjMTggc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGMxOD4wKSwNCmMxOSBzZXJp YWwgdW5pcXVlICAgY2hlY2soYzE5PjApLCANCmMyMCBzZXJpYWwgdW5pcXVl ICAgY2hlY2soYzIwPjApLCANCmMyMSBzZXJpYWwgdW5pcXVlICAgY2hlY2so YzIxPjApLCANCmMyMiBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzIyPjApLA0K YzIzIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjMjM+MCksIA0KYzI0IHNlcmlh bCB1bmlxdWUgICBjaGVjayhjMjQ+MCksDQpjMjUgc2VyaWFsIHVuaXF1ZSAg IGNoZWNrKGMyNT4wKSwgDQpjMjYgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGMy Nj4wKSwNCmMyNyBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzI3PjApLCANCmMy OCBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzI4PjApLA0KYzI5IHNlcmlhbCB1 bmlxdWUgICBjaGVjayhjMjk+MCksIA0KYzMwIHNlcmlhbCB1bmlxdWUgICBj aGVjayhjMzA+MCksIA0KYzMxIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjMzE+ MCksIA0KYzMyIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjMzI+MCksDQpjMzMg c2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGMzMz4wKSwgDQpjMzQgc2VyaWFsIHVu aXF1ZSAgIGNoZWNrKGMzND4wKSwNCmMzNSBzZXJpYWwgdW5pcXVlICAgY2hl Y2soYzM1PjApLCANCmMzNiBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzM2PjAp LA0KYzM3IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjMzc+MCksIA0KYzM4IHNl cmlhbCB1bmlxdWUgICBjaGVjayhjMzg+MCksDQpjMzkgc2VyaWFsIHVuaXF1 ZSAgIGNoZWNrKGMzOT4wKSwgDQpjNDAgc2VyaWFsIHVuaXF1ZSAgIGNoZWNr KGM0MD4wKSwgDQpjNDEgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM0MT4wKSwg DQpjNDIgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM0Mj4wKSwNCmM0MyBzZXJp YWwgdW5pcXVlICAgY2hlY2soYzQzPjApLCANCmM0NCBzZXJpYWwgdW5pcXVl ICAgY2hlY2soYzQ0PjApLA0KYzQ1IHNlcmlhbCB1bmlxdWUgICBjaGVjayhj NDU+MCksIA0KYzQ2IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjNDY+MCksDQpj NDcgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM0Nz4wKSwgDQpjNDggc2VyaWFs IHVuaXF1ZSAgIGNoZWNrKGM0OD4wKSwNCmM0OSBzZXJpYWwgdW5pcXVlICAg Y2hlY2soYzQ5PjApLCANCmM1MCBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzUw PjApLCANCmM1MSBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzUxPjApLCANCmM1 MiBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzUyPjApLA0KYzUzIHNlcmlhbCB1 bmlxdWUgICBjaGVjayhjNTM+MCksIA0KYzU0IHNlcmlhbCB1bmlxdWUgICBj aGVjayhjNTQ+MCksDQpjNTUgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM1NT4w KSwgDQpjNTYgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM1Nj4wKSwNCmM1NyBz ZXJpYWwgdW5pcXVlICAgY2hlY2soYzU3PjApLCANCmM1OCBzZXJpYWwgdW5p cXVlICAgY2hlY2soYzU4PjApLA0KYzU5IHNlcmlhbCB1bmlxdWUgICBjaGVj ayhjNTk+MCksIA0KYzYwIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjNjA+MCks IA0KYzYxIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjNjE+MCksIA0KYzYyIHNl cmlhbCB1bmlxdWUgICBjaGVjayhjNjI+MCksDQpjNjMgc2VyaWFsIHVuaXF1 ZSAgIGNoZWNrKGM2Mz4wKSwgDQpjNjQgc2VyaWFsIHVuaXF1ZSAgIGNoZWNr KGM2ND4wKSwNCmM2NSBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzY1PjApLCAN CmM2NiBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzY2PjApLA0KYzY3IHNlcmlh bCB1bmlxdWUgICBjaGVjayhjNjc+MCksIA0KYzY4IHNlcmlhbCB1bmlxdWUg ICBjaGVjayhjNjg+MCksDQpjNjkgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM2 OT4wKSwgDQpjNzAgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM3MD4wKSwgDQpj NzEgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM3MT4wKSwgDQpjNzIgc2VyaWFs IHVuaXF1ZSAgIGNoZWNrKGM3Mj4wKSwNCmM3MyBzZXJpYWwgdW5pcXVlICAg Y2hlY2soYzczPjApLCANCmM3NCBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzc0 PjApLA0KYzc1IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjNzU+MCksIA0KYzc2 IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjNzY+MCksDQpjNzcgc2VyaWFsIHVu aXF1ZSAgIGNoZWNrKGM3Nz4wKSwgDQpjNzggc2VyaWFsIHVuaXF1ZSAgIGNo ZWNrKGM3OD4wKSwNCmM3OSBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzc5PjAp LCANCmM4MCBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzgwPjApLCANCmM4MSBz ZXJpYWwgdW5pcXVlICAgY2hlY2soYzgxPjApLCANCmM4MiBzZXJpYWwgdW5p cXVlICAgY2hlY2soYzgyPjApLA0KYzgzIHNlcmlhbCB1bmlxdWUgICBjaGVj ayhjODM+MCksIA0KYzg0IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjODQ+MCks DQpjODUgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM4NT4wKSwgDQpjODYgc2Vy aWFsIHVuaXF1ZSAgIGNoZWNrKGM4Nj4wKSwNCmM4NyBzZXJpYWwgdW5pcXVl ICAgY2hlY2soYzg3PjApLCANCmM4OCBzZXJpYWwgdW5pcXVlICAgY2hlY2so Yzg4PjApLA0KYzg5IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjODk+MCksIA0K YzkwIHNlcmlhbCB1bmlxdWUgICBjaGVjayhjOTA+MCksIA0KYzkxIHNlcmlh bCB1bmlxdWUgICBjaGVjayhjOTE+MCksIA0KYzkyIHNlcmlhbCB1bmlxdWUg ICBjaGVjayhjOTI+MCksDQpjOTMgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM5 Mz4wKSwgDQpjOTQgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM5ND4wKSwNCmM5 NSBzZXJpYWwgdW5pcXVlICAgY2hlY2soYzk1PjApLCANCmM5NiBzZXJpYWwg dW5pcXVlICAgY2hlY2soYzk2PjApLA0KYzk3IHNlcmlhbCB1bmlxdWUgICBj aGVjayhjOTc+MCksIA0KYzk4IHNlcmlhbCB1bmlxdWUgICBjaGVjayhjOTg+ MCksDQpjOTkgc2VyaWFsIHVuaXF1ZSAgIGNoZWNrKGM5OT4wKQ0KKTsNCg0K DQoNCmRvIGxhbmd1YWdlIHBscGdzcWwgJCQgICAgICAgICANCmRlY2xhcmUN CiAgaSBpbnQgOw0KYmVnaW4NCiAgZm9yIGkgaW4gMS4uNTAwIGxvb3ANCiAg ICBleGVjdXRlICdjcmVhdGUgdGFibGUgdGVzdCd8fGl8fCcgKGxpa2UgdGVz dCBpbmNsdWRpbmcgYWxsKSc7DQogIGVuZCBsb29wOw0KZW5kOw0KJCQ7DQoN Cg0KcG9zdGdyZXM9IyBcbCsNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YK ZGF0YWJhc2VzDQogICBOYW1lICAgIHwgIE93bmVyICAgfCBFbmNvZGluZyB8 IENvbGxhdGUgfCBDdHlwZSB8ICAgQWNjZXNzIHByaXZpbGVnZXMgICB8CiBT aXplICAgfCBUYWJsZXNwYWNlIHwgICAgICAgICAgICAgICAgRGVzY3JpcHRp b24gICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0rLS0tLS0tLS0tLSst LS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBwb3N0Z3JlcyAgfCBw b3N0Z3JlcyB8IFVURjggICAgIHwgQyAgICAgICB8IEMgICAgIHwgICAgICAg ICAgICAgICAgICAgICAgIHwKNTc4IE1CICB8IHBnX2RlZmF1bHQgfCBkZWZh dWx0IGFkbWluaXN0cmF0aXZlIGNvbm5lY3Rpb24gZGF0YWJhc2UNCiB0ZW1w bGF0ZTAgfCBwb3N0Z3JlcyB8IFVURjggICAgIHwgQyAgICAgICB8IEMgICAg IHwgPWMvcG9zdGdyZXMgICAgICAgICAgK3wKNzIyNSBrQiB8IHBnX2RlZmF1 bHQgfCB1bm1vZGlmaWFibGUgZW1wdHkgZGF0YWJhc2UNCiAgICAgICAgICAg fCAgICAgICAgICB8ICAgICAgICAgIHwgICAgICAgICB8ICAgICAgIHwgcG9z dGdyZXM9Q1RjL3Bvc3RncmVzIHwKICAgICAgICB8ICAgICAgICAgICAgfCAN CiB0ZW1wbGF0ZTEgfCBwb3N0Z3JlcyB8IFVURjggICAgIHwgQyAgICAgICB8 IEMgICAgIHwgPWMvcG9zdGdyZXMgICAgICAgICAgK3wKNzIyNSBrQiB8IHBn X2RlZmF1bHQgfCBkZWZhdWx0IHRlbXBsYXRlIGZvciBuZXcgZGF0YWJhc2Vz DQogICAgICAgICAgIHwgICAgICAgICAgfCAgICAgICAgICB8ICAgICAgICAg fCAgICAgICB8IHBvc3RncmVzPUNUYy9wb3N0Z3JlcyB8CiAgICAgICAgfCAg ICAgICAgICAgIHwgDQooMyByb3dzKQ0KDQoNClxjIHRlbXBsYXRlMQ0KdGVt cGxhdGUxPSMgY3JlYXRlIGRhdGFiYXNlIGRiMCB3aXRoIHRlbXBsYXRlIHBv c3RncmVzOw0KDQoNCnRlbXBsYXRlMT0jIHNlbGVjdCBwZ19jdXJyZW50X3hs b2dfbG9jYXRpb24oKTsNCiBwZ19jdXJyZW50X3hsb2dfbG9jYXRpb24gDQot LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDAvMTVFRjU1RTANCigxIHJv dykNCg0KDQpcYyBkYjANCg0KZHJvcCBzY2hlbWEgcHVibGljIGNhc2NhZGU7 DQoNCg0KDQpkYjA9IyBzZWxlY3QgcGdfY3VycmVudF94bG9nX2xvY2F0aW9u KCk7DQotWyBSRUNPUkQgMSBdLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tDQpw Z19jdXJyZW50X3hsb2dfbG9jYXRpb24gfCAxLzE2OEU2RUE4DQoNCmBgYA0K DQpvbiBwcmltYXJ5ICwgbW9uaXRvcnkgdGhlIHNlbmQsIHdyaXRlLCBmbHVz aCwgYXBwbHkgeGxvZyBkZWxheSAgDQpgYGANCg0KXHgNCg0Kc2VsZWN0IA0K cGdfc2l6ZV9wcmV0dHkocGdfeGxvZ19sb2NhdGlvbl9kaWZmKHBnX2N1cnJl bnRfeGxvZ19sb2NhdGlvbigpLHNlbnRfbG9jYXRpb24pKSwNCnBnX3NpemVf cHJldHR5KHBnX3hsb2dfbG9jYXRpb25fZGlmZihwZ19jdXJyZW50X3hsb2df bG9jYXRpb24oKSx3cml0ZV9sb2NhdGlvbikpLA0KcGdfc2l6ZV9wcmV0dHko cGdfeGxvZ19sb2NhdGlvbl9kaWZmKHBnX2N1cnJlbnRfeGxvZ19sb2NhdGlv bigpLGZsdXNoX2xvY2F0aW9uKSksDQpwZ19zaXplX3ByZXR0eShwZ194bG9n X2xvY2F0aW9uX2RpZmYocGdfY3VycmVudF94bG9nX2xvY2F0aW9uKCkscmVw bGF5X2xvY2F0aW9uKSksCg0KKiBmcm9tIHBnX3N0YXRfcmVwbGljYXRpb24g Ow0KDQpcd2F0Y2ggMQ0KDQoNCg0KDQotWyBSRUNPUkQgMSBdLS0tLSstLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCnBnX3NpemVfcHJldHR5ICAg fCAwIGJ5dGVzDQpwZ19zaXplX3ByZXR0eSAgIHwgMCBieXRlcw0KcGdfc2l6 ZV9wcmV0dHkgICB8IDAgYnl0ZXMNCnBnX3NpemVfcHJldHR5ICAgfCA1NiBN Qg0KcGlkICAgICAgICAgICAgICB8IDg4MDQyDQp1c2VzeXNpZCAgICAgICAg IHwgMTANCnVzZW5hbWUgICAgICAgICAgfCBwb3N0Z3Jlcw0KYXBwbGljYXRp b25fbmFtZSB8IHdhbHJlY2VpdmVyDQpjbGllbnRfYWRkciAgICAgIHwgMTI3 LjAuMC4xDQpjbGllbnRfaG9zdG5hbWUgIHwgDQpjbGllbnRfcG9ydCAgICAg IHwgMTkyMjQNCmJhY2tlbmRfc3RhcnQgICAgfCAyMDE2LTEwLTE4IDE1OjM1 OjQ5LjQ2MDM2NiswOA0KYmFja2VuZF94bWluICAgICB8IDE2OTkNCnN0YXRl ICAgICAgICAgICAgfCBzdHJlYW1pbmcNCnNlbnRfbG9jYXRpb24gICAgfCAw LzI0QTk3OTQ4DQp3cml0ZV9sb2NhdGlvbiAgIHwgMC8yNEE5Nzk0OA0KZmx1 c2hfbG9jYXRpb24gICB8IDAvMjRBOTc5NDgNCnJlcGxheV9sb2NhdGlvbiAg fCAwLzIxMkIxNzkwDQpzeW5jX3ByaW9yaXR5ICAgIHwgMA0Kc3luY19zdGF0 ZSAgICAgICB8IGFzeW5jDQoNCmBgYA0KDQpvbiBzdGFuZGJ5ICANCmBgYA0K cmVjb3ZlcnkgcHJvY2VzczoNCg0KIDg4MDQwICA4NzgyOCAyNyAxNTozNSA/ ICAgICAgICAwMDowMjo1NiBwb3N0Z3Jlczogc3RhcnR1cCBwcm9jZXNzICAK cmVjb3ZlcmluZyAwMDAwMDAwMTAwMDAwMDAwMDAwMDAwMjINCg0Kd2hhdCB0 byBkbz8NCg0Kc3RyYWNlIC1wIDg4MDQwDQoNCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMzgiKSAgICAgICAgICAgICA9IDANCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMzguMSIpICAgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBm aWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzhf ZnNtIikgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRp cmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzhfdm0iKSAgICAg ICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzhfaW5pdCIpICAgICAgICA9IC0x IEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygi YmFzZS8yMTg0OTIvNjgwMzYiKSAgICAgICAgICAgICA9IDANCnVubGluaygi YmFzZS8yMTg0OTIvNjgwMzYuMSIpICAgICAgICAgICA9IC0xIEVOT0VOVCAo Tm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMzZfZnNtIikgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBm aWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzZf dm0iKSAgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRp cmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzZfaW5pdCIpICAg ICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzQiKSAgICAgICAgICAgICA9IDAN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzQuMSIpICAgICAgICAgICA9IC0x IEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygi YmFzZS8yMTg0OTIvNjgwMzRfZnNtIikgICAgICAgICA9IC0xIEVOT0VOVCAo Tm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMzRfdm0iKSAgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBm aWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzRf aW5pdCIpICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRp cmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzIiKSAgICAgICAg ICAgICA9IDANCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzIuMSIpICAgICAg ICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzJfZnNtIikgICAgICAgICA9IC0x IEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygi YmFzZS8yMTg0OTIvNjgwMzJfdm0iKSAgICAgICAgICA9IC0xIEVOT0VOVCAo Tm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMzJfaW5pdCIpICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBm aWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzAi KSAgICAgICAgICAgICA9IDANCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzAu MSIpICAgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRp cmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzBfZnNtIikgICAg ICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMzBfdm0iKSAgICAgICAgICA9IC0x IEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygi YmFzZS8yMTg0OTIvNjgwMzBfaW5pdCIpICAgICAgICA9IC0xIEVOT0VOVCAo Tm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMjgiKSAgICAgICAgICAgICA9IDANCnVubGluaygiYmFzZS8yMTg0 OTIvNjgwMjguMSIpICAgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBm aWxlIG9yCmRpcmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMjhf ZnNtIikgICAgICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRp cmVjdG9yeSkNCnVubGluaygiYmFzZS8yMTg0OTIvNjgwMjhfdm0iKSAgICAg ICAgICA9IC0xIEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkN CnVubGluaygiYmFzZS8yMTg0OTIvNjgwMjhfaW5pdCIpICAgICAgICA9IC0x IEVOT0VOVCAoTm8gc3VjaCBmaWxlIG9yCmRpcmVjdG9yeSkNCg0KYGBgDQpz byB0aGlzIHhsb2cgcmVjb3JkIGFwcGx5IHZlcnkgc2xvdywgYnV0IHdoeSBp dCdzIHF1aWNrIG9uIHByaW1hcnk/IA0KDQp0aGUgeGxvZyByZWNvcmQgYW5h bHl6ZSA6ICAgDQpgYGANCg0KcGdfeGxvZ2R1bXAgLWIgMDAwMDAwMDEwMDAw MDAwMDAwMDAwMDIxIDAwMDAwMDAxMDAwMDAwMDAwMDAwMDAyMiAyPiYxCnxs ZXNzDQpzZWFyY2ggMC8yMTJCMTc5MA0KdGhpcyByZWRvIHNpemUgMTc2ODA4 NDAgYnl0ZXMsIHZlcnkgbGFyZ2UNCg0Kcm1ncjogVHJhbnNhY3Rpb24gbGVu IChyZWMvdG90KTogMTc2ODA4NDAvMTc2ODA4NjksIHR4OiAgICAgICAxNjk4 LCBsc246CjAvMjEyQjE3OTAsIHByZXYgMC8yMTJCMEFFMCwgZGVzYzogQ09N TUlUIDIwMTYtMTAtMTggMTU6NDQ6MDYuNTYzODM4IENTVDsKcmVsczogDQpi YXNlLzIxODQ5Mi8xMTE2OTQgYmFzZS8yMTg0OTIvMTEyMDk1IGJhc2UvMjE4 NDkyLzExMjA5MyBiYXNlLzIxODQ5Mi8xMTIwOTEKYmFzZS8yMTg0OTIvMTEy MDg5IGJhc2UvMjE4NDkyLzExMjA4NyBiYXNlLzIxODQ5Mi8xMTIwODUgYmFz ZS8yMTg0OTIvMTEyMDgzCg0KYmFzZS8yMTg0OTIvMTEyMDgxIGJhc2UvMjE4 NDkyLzExMjA3OSBiYXNlLzIxODQ5Mi8xMTIwNzcgYmFzZS8yMTg0OTIvMTEy MDc1CmJhc2UvMjE4NDkyLzExMjA3MyBiYXNlLzIxODQ5Mi8xMTIwNzEgYmFz ZS8yMTg0OTIvMTEyMDY5IGJhc2UvMjE4NDkyLzExMjA2NwoNCmJhc2UvMjE4 NDkyLzExMjA2NSBiYXNlLzIxODQ5Mi8xMTIwNjMgYmFzZS8yMTg0OTIvMTEy MDYxIGJhc2UvMjE4NDkyLzExMjA1OQpiYXNlLzIxODQ5Mi8xMTIwNTcgYmFz ZS8yMTg0OTIvMTEyMDU1IGJhc2UvMjE4NDkyLzExMjA1MyBiYXNlLzIxODQ5 Mi8xMTIwNTEKDQpiYXNlLzIxODQ5Mi8xMTIwNDkgYmFzZS8yMTg0OTIvMTEy MDQ3IGJhc2UvMjE4NDkyLzExMjA0NSBiYXNlLzIxODQ5Mi8xMTIwNDMKYmFz ZS8yMTg0OTIvMTEyMDQxIGJhc2UvMjE4NDkyLzExMjAzOSBiYXNlLzIxODQ5 Mi8xMTIwMzcgYmFzZS8yMTg0OTIvMTEyMDM1Cg0KYmFzZS8yMTg0OTIvMTEy MDMzIGJhc2UvMjE4NDkyLzExMjAzMSBiYXNlLzIxODQ5Mi8xMTIwMjkgDQou Li4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uLi4uDQpyZWxjYWNoZSAyMTgzMDUg cmVsY2FjaGUgMjE4MDg2IHNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4MDg2 IHNuYXBzaG90IDI2MDgKcmVsY2FjaGUgMjE4MDg2IHNuYXBzaG90IDI2MDgg c25hcHNob3QgMjYwOCByZWxjYWNoZSAyMTgzMDMgcmVsY2FjaGUgMjE4MDg2 Cg0Kc25hcHNob3QgMjYwOCByZWxjYWNoZSAyMTgwODYgc25hcHNob3QgMjYw OCByZWxjYWNoZSAyMTgwODYgc25hcHNob3QgMjYwOApzbmFwc2hvdCAyNg0K MDggcmVsY2FjaGUgMjE4MzAxIHJlbGNhY2hlIDIxODA4NiBzbmFwc2hvdCAy NjA4IHJlbGNhY2hlIDIxODA4NiBzbmFwc2hvdAoyNjA4IHJlbGNhY2hlIDIx ODA4NiBzbmFwc2hvdCAyNjA4IHNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4 Mjk5IHJlbGNhY2hlCjIxODA4NiANCnNuYXBzaG90IDI2MDggcmVsY2FjaGUg MjE4MDg2IHNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4MDg2IHNuYXBzaG90 IDI2MDgKc25hcHNob3QNCiAyNjA4IHJlbGNhY2hlIDIxODI5NyByZWxjYWNo ZSAyMTgwODYgc25hcHNob3QgMjYwOCByZWxjYWNoZSAyMTgwODYgc25hcHNo b3QKMjYwOCByZWxjYWNoZSAyMTgwODYgc25hcHNob3QgMjYwOCBzbmFwc2hv dCAyNjA4IHJlbGNhY2hlIDIxODI5NSByZWxjYWNoZQoyMTgwODYgDQogc25h cHNob3QgMjYwOCByZWxjYWNoZSAyMTgwODYgc25hcHNob3QgMjYwOCByZWxj YWNoZSAyMTgwODYgc25hcHNob3QgMjYwOApzbmFwcw0KaG90IDI2MDggcmVs Y2FjaGUgMjE4MjkzIHJlbGNhY2hlIDIxODA4NiBzbmFwc2hvdCAyNjA4IHJl bGNhY2hlIDIxODA4NgpzbmFwc2hvdCAyNjA4IHJlbGNhY2hlIDIxODA4NiBz bmFwc2hvdCAyNjA4IHNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4MjkxCnJl bGNhY2hlIDIxODA4NiANCnNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4MDg2 IHNuYXBzaG90IDI2MDggcmVsY2FjaGUgMjE4MDg2IHNuYXBzaG90IDI2MDgK c24NCmFwc2hvdCAyNjA4IHJlbGNhY2hlIDIxODI4OSByZWxjYWNoZSAyMTgw ODYgc25hcHNob3QgMjYwOCBzbmFwc2hvdCAyNjA4CnNuYXBzaG90IDI2MDgN Ci4uLi4uLi4uLi4uLi4uDQpybWdyOiBIZWFwMiAgICAgICBsZW4gKHJlYy90 b3QpOiAgICAgIDgvICAgIDYyLCB0eDogICAgICAgICAgMCwgbHNuOgowLzIy MzlBQzgwLCBwcmV2IDAvMjEyQjE3OTAsIGRlc2M6IENMRUFOIHJlbXhpZCAx Njk4DQogICAgICAgIGJsa3JlZiAjMDogcmVsIDE2NjMvMjE4NDkyLzEyNTkg Zm9yayBtYWluIGJsayAzDQoNCmBgYA0KDQoKCg==
On 10/18/2016 12:57 AM, digoal@126.com wrote: > when i use postgresql 9.6.0 for primary-standby, i drop a schema on primary, > but it's apply very slow on standby. > > the wal send very fast, but apply very slow, i think the syscall more than > it on primary? your table has 100 associated sequences, and 100 associated indexes, along with 100 expression constraints?, and you're creating 500 of these? thats quite a lot of metadata. -- john r pierce, recycling bits in santa cruz
On 2016-10-18 07:57:33 +0000, digoal@126.com wrote: > The following bug has been logged on the website: > > Bug reference: 14378 > Logged by: Zhou Digoal > Email address: digoal@126.com > PostgreSQL version: 9.6.0 > Operating system: CentOS 6.x x64 > Description: > > > > when i use postgresql 9.6.0 for primary-standby, i drop a schema on primary, > but it's apply very slow on standby. > > the wal send very fast, but apply very slow, i think the syscall more than > it on primary? > > this is my test: There's some O(n^2) behaviour around lock release and acquire during replay IIRC. See for example the thread around http://archives.postgresql.org/message-id/20140630231741.GA30918%40alap3.anarazel.de It's not entirely trivial to fix that though. E.g. the patch of Simon's later in that thread wouldn't help in your situation. Greetings, Andres Freund
HI,
Thanks Andres Freund's replay.
Btw, schema not like database in file struct, it has no directory entry below the database directory.
database has a dir below tablespace dir. but schema no dir below the database dir .
so drop schema must deal files one-by-one?
but drop database can drop dir only?
best regards.
--
公益是一辈子的事,I'm Digoal,Just Do It.
公益是一辈子的事,I'm Digoal,Just Do It.
At 2016-10-19 02:32:08, "Andres Freund" <andres@anarazel.de> wrote: >On 2016-10-18 07:57:33 +0000, digoal@126.com wrote: >> The following bug has been logged on the website: >> >> Bug reference: 14378 >> Logged by: Zhou Digoal >> Email address: digoal@126.com >> PostgreSQL version: 9.6.0 >> Operating system: CentOS 6.x x64 >> Description: >> >> >> >> when i use postgresql 9.6.0 for primary-standby, i drop a schema on primary, >> but it's apply very slow on standby. >> >> the wal send very fast, but apply very slow, i think the syscall more than >> it on primary? >> >> this is my test: > >There's some O(n^2) behaviour around lock release and acquire during >replay IIRC. See for example the thread around >http://archives.postgresql.org/message-id/20140630231741.GA30918%40alap3.anarazel.de > >It's not entirely trivial to fix that though. E.g. the patch of Simon's >later in that thread wouldn't help in your situation. > >Greetings, > >Andres Freund
HI,
Add some info when i use perf top.
1\. when drop schema on primary (search depend)
```
findDependentObjects /home/digoal/pgsql9.6/bin/postgres
3745.00 11.3% get_tabstat_entry /home/digoal/pgsql9.6/bin/postgres
```
2\. when drop schema start (drop files)
```
5862.00 17.7% DropRelFileNodesAllBuffers /home/digoal/pgsql9.6/bin/postgres
4058.00 12.2% smgrclose /home/digoal/pgsql9.6/bin/postgres
```
3\. when apply on standby
```
12464.00 92.5% DropRelFileNodesAllBuffers /home/digoal/pgsql9.6/bin/postgres
56.00 0.6% DropRelFileNodeBuffers /home/digoal/pgsql9.6/bin/postgres
```
best regards.
--
公益是一辈子的事,I'm Digoal,Just Do It.
公益是一辈子的事,I'm Digoal,Just Do It.
At 2016-10-19 02:32:08, "Andres Freund" <andres@anarazel.de> wrote: >On 2016-10-18 07:57:33 +0000, digoal@126.com wrote: >> The following bug has been logged on the website: >> >> Bug reference: 14378 >> Logged by: Zhou Digoal >> Email address: digoal@126.com >> PostgreSQL version: 9.6.0 >> Operating system: CentOS 6.x x64 >> Description: >> >> >> >> when i use postgresql 9.6.0 for primary-standby, i drop a schema on primary, >> but it's apply very slow on standby. >> >> the wal send very fast, but apply very slow, i think the syscall more than >> it on primary? >> >> this is my test: > >There's some O(n^2) behaviour around lock release and acquire during >replay IIRC. See for example the thread around >http://archives.postgresql.org/message-id/20140630231741.GA30918%40alap3.anarazel.de > >It's not entirely trivial to fix that though. E.g. the patch of Simon's >later in that thread wouldn't help in your situation. > >Greetings, > >Andres Freund