Thread: 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?

From

digoal@126.com

Date:

18 October 2016, 10:58:13

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==

Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?

From

John R Pierce

Date:

18 October 2016, 21:25:07

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

Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?

From

Andres Freund

Date:

18 October 2016, 21:32:13

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

Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?

From

德哥

Date:

19 October 2016, 04:23:09

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.


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

Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug?

From

德哥

Date:

19 October 2016, 04:47:38

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.


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