BUG #14365: drop big schema will hang the standby's apply

Поиск
Список
Период
Сортировка
От digoal@126.com
Тема BUG #14365: drop big schema will hang the standby's apply
Дата
Msg-id 20161011113026.1412.57124@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM2NQpMb2dnZWQgYnk6ICAg
ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs
QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjQuOQpPcGVyYXRpbmcg
c3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAgICAg
CgpXaGVuIGkgZHJvcCBhIGJpZyBzY2hlbWEgaW4gbWFzdGVyLCB0aGUgc3Rh
bmRieSBhcHBseSB3aWxsIGhhbmcgKHZlcnkgdmVyeQpzbG93KS4gIA0KDQpt
YXN0ZXIgOiANCg0KY29ubmVjdCB0byB0ZW1wbGF0ZTENCmBgYA0KY3JlYXRl
IHRhYmxlIHRlc3QoDQpjMCBpbnQgICAgY2hlY2soYzA+MCksIA0KYzEgaW50
ICAgIGNoZWNrKGMxPjApLCANCmMyIGludCAgICBjaGVjayhjMj4wKSwNCmMz
IGludCAgICBjaGVjayhjMz4wKSwgDQpjNCBpbnQgICAgY2hlY2soYzQ+MCks
DQpjNSBpbnQgICAgY2hlY2soYzU+MCksIA0KYzYgaW50ICAgIGNoZWNrKGM2
PjApLA0KYzcgaW50ICAgIGNoZWNrKGM3PjApLCANCmM4IGludCAgICBjaGVj
ayhjOD4wKSwNCmM5IGludCAgICBjaGVjayhjOT4wKSwgDQpjMTAgaW50ICAg
IGNoZWNrKGMxMD4wKSwgDQpjMTEgaW50ICAgIGNoZWNrKGMxMT4wKSwgDQpj
MTIgaW50ICAgIGNoZWNrKGMxMj4wKSwNCmMxMyBpbnQgICAgY2hlY2soYzEz
PjApLCANCmMxNCBpbnQgICAgY2hlY2soYzE0PjApLA0KYzE1IGludCAgICBj
aGVjayhjMTU+MCksIA0KYzE2IGludCAgICBjaGVjayhjMTY+MCksDQpjMTcg
aW50ICAgIGNoZWNrKGMxNz4wKSwgDQpjMTggaW50ICAgIGNoZWNrKGMxOD4w
KSwNCmMxOSBpbnQgICAgY2hlY2soYzE5PjApLCANCmMyMCBpbnQgICAgY2hl
Y2soYzIwPjApLCANCmMyMSBpbnQgICAgY2hlY2soYzIxPjApLCANCmMyMiBp
bnQgICAgY2hlY2soYzIyPjApLA0KYzIzIGludCAgICBjaGVjayhjMjM+MCks
IA0KYzI0IGludCAgICBjaGVjayhjMjQ+MCksDQpjMjUgaW50ICAgIGNoZWNr
KGMyNT4wKSwgDQpjMjYgaW50ICAgIGNoZWNrKGMyNj4wKSwNCmMyNyBpbnQg
ICAgY2hlY2soYzI3PjApLCANCmMyOCBpbnQgICAgY2hlY2soYzI4PjApLA0K
YzI5IGludCAgICBjaGVjayhjMjk+MCksIA0KYzMwIGludCAgICBjaGVjayhj
MzA+MCksIA0KYzMxIGludCAgICBjaGVjayhjMzE+MCksIA0KYzMyIGludCAg
ICBjaGVjayhjMzI+MCksDQpjMzMgaW50ICAgIGNoZWNrKGMzMz4wKSwgDQpj
MzQgaW50ICAgIGNoZWNrKGMzND4wKSwNCmMzNSBpbnQgICAgY2hlY2soYzM1
PjApLCANCmMzNiBpbnQgICAgY2hlY2soYzM2PjApLA0KYzM3IGludCAgICBj
aGVjayhjMzc+MCksIA0KYzM4IGludCAgICBjaGVjayhjMzg+MCksDQpjMzkg
aW50ICAgIGNoZWNrKGMzOT4wKSwgDQpjNDAgaW50ICAgIGNoZWNrKGM0MD4w
KSwgDQpjNDEgaW50ICAgIGNoZWNrKGM0MT4wKSwgDQpjNDIgaW50ICAgIGNo
ZWNrKGM0Mj4wKSwNCmM0MyBpbnQgICAgY2hlY2soYzQzPjApLCANCmM0NCBp
bnQgICAgY2hlY2soYzQ0PjApLA0KYzQ1IGludCAgICBjaGVjayhjNDU+MCks
IA0KYzQ2IGludCAgICBjaGVjayhjNDY+MCksDQpjNDcgaW50ICAgIGNoZWNr
KGM0Nz4wKSwgDQpjNDggaW50ICAgIGNoZWNrKGM0OD4wKSwNCmM0OSBpbnQg
ICAgY2hlY2soYzQ5PjApLCANCmM1MCBpbnQgICAgY2hlY2soYzUwPjApLCAN
CmM1MSBpbnQgICAgY2hlY2soYzUxPjApLCANCmM1MiBpbnQgICAgY2hlY2so
YzUyPjApLA0KYzUzIGludCAgICBjaGVjayhjNTM+MCksIA0KYzU0IGludCAg
ICBjaGVjayhjNTQ+MCksDQpjNTUgaW50ICAgIGNoZWNrKGM1NT4wKSwgDQpj
NTYgaW50ICAgIGNoZWNrKGM1Nj4wKSwNCmM1NyBpbnQgICAgY2hlY2soYzU3
PjApLCANCmM1OCBpbnQgICAgY2hlY2soYzU4PjApLA0KYzU5IGludCAgICBj
aGVjayhjNTk+MCksIA0KYzYwIGludCAgICBjaGVjayhjNjA+MCksIA0KYzYx
IGludCAgICBjaGVjayhjNjE+MCksIA0KYzYyIGludCAgICBjaGVjayhjNjI+
MCksDQpjNjMgaW50ICAgIGNoZWNrKGM2Mz4wKSwgDQpjNjQgaW50ICAgIGNo
ZWNrKGM2ND4wKSwNCmM2NSBpbnQgICAgY2hlY2soYzY1PjApLCANCmM2NiBp
bnQgICAgY2hlY2soYzY2PjApLA0KYzY3IGludCAgICBjaGVjayhjNjc+MCks
IA0KYzY4IGludCAgICBjaGVjayhjNjg+MCksDQpjNjkgaW50ICAgIGNoZWNr
KGM2OT4wKSwgDQpjNzAgaW50ICAgIGNoZWNrKGM3MD4wKSwgDQpjNzEgaW50
ICAgIGNoZWNrKGM3MT4wKSwgDQpjNzIgaW50ICAgIGNoZWNrKGM3Mj4wKSwN
CmM3MyBpbnQgICAgY2hlY2soYzczPjApLCANCmM3NCBpbnQgICAgY2hlY2so
Yzc0PjApLA0KYzc1IGludCAgICBjaGVjayhjNzU+MCksIA0KYzc2IGludCAg
ICBjaGVjayhjNzY+MCksDQpjNzcgaW50ICAgIGNoZWNrKGM3Nz4wKSwgDQpj
NzggaW50ICAgIGNoZWNrKGM3OD4wKSwNCmM3OSBpbnQgICAgY2hlY2soYzc5
PjApLCANCmM4MCBpbnQgICAgY2hlY2soYzgwPjApLCANCmM4MSBpbnQgICAg
Y2hlY2soYzgxPjApLCANCmM4MiBpbnQgICAgY2hlY2soYzgyPjApLA0KYzgz
IGludCAgICBjaGVjayhjODM+MCksIA0KYzg0IGludCAgICBjaGVjayhjODQ+
MCksDQpjODUgaW50ICAgIGNoZWNrKGM4NT4wKSwgDQpjODYgaW50ICAgIGNo
ZWNrKGM4Nj4wKSwNCmM4NyBpbnQgICAgY2hlY2soYzg3PjApLCANCmM4OCBp
bnQgICAgY2hlY2soYzg4PjApLA0KYzg5IGludCAgICBjaGVjayhjODk+MCks
IA0KYzkwIGludCAgICBjaGVjayhjOTA+MCksIA0KYzkxIGludCAgICBjaGVj
ayhjOTE+MCksIA0KYzkyIGludCAgICBjaGVjayhjOTI+MCksDQpjOTMgaW50
ICAgIGNoZWNrKGM5Mz4wKSwgDQpjOTQgaW50ICAgIGNoZWNrKGM5ND4wKSwN
CmM5NSBpbnQgICAgY2hlY2soYzk1PjApLCANCmM5NiBpbnQgICAgY2hlY2so
Yzk2PjApLA0KYzk3IGludCAgICBjaGVjayhjOTc+MCksIA0KYzk4IGludCAg
ICBjaGVjayhjOTg+MCksDQpjOTkgaW50ICAgIGNoZWNrKGM5OT4wKQ0KKTsN
Cg0KDQoNCg0KZG8gbGFuZ3VhZ2UgcGxwZ3NxbCAkJCAgICAgICAgIA0KZGVj
bGFyZQ0KICBpIGludCA7DQpiZWdpbg0KICBmb3IgaSBpbiAxLi41MDAwIGxv
b3ANCiAgICBleGVjdXRlICdjcmVhdGUgdGFibGUgdGVzdCd8fGl8fCcgKGxp
a2UgdGVzdCBpbmNsdWRpbmcgYWxsKSc7DQogIGVuZCBsb29wOw0KZW5kOw0K
JCQ7DQpgYGANCg0KYGBgDQpjcmVhdGUgZGF0YWJhc2UgdGVzdCB3aXRoIHRl
bXBsYXRlMTsNClxjIHRlc3QNCmRyb3Agc2NoZW1hIHB1YmxpYyBjYXNjYWRl
Ow0KYGBgDQoNCmFuZCBzZWUgdGhlIGRlbGF5IHdpdGggdGhpcyBxdWVyeToN
CmBgYA0Kc2VsZWN0ICANCnBnX3NpemVfcHJldHR5KHBnX3hsb2dfbG9jYXRp
b25fZGlmZihwZ19jdXJyZW50X3hsb2dfbG9jYXRpb24oKSxzZW50X2xvY2F0
aW9uKSksDQpwZ19zaXplX3ByZXR0eShwZ194bG9nX2xvY2F0aW9uX2RpZmYo
cGdfY3VycmVudF94bG9nX2xvY2F0aW9uKCksd3JpdGVfbG9jYXRpb24pKSwN
CnBnX3NpemVfcHJldHR5KHBnX3hsb2dfbG9jYXRpb25fZGlmZihwZ19jdXJy
ZW50X3hsb2dfbG9jYXRpb24oKSxmbHVzaF9sb2NhdGlvbikpLA0KcGdfc2l6
ZV9wcmV0dHkocGdfeGxvZ19sb2NhdGlvbl9kaWZmKHBnX2N1cnJlbnRfeGxv
Z19sb2NhdGlvbigpLHJlcGxheV9sb2NhdGlvbikpLAoNCiogZnJvbSBwZ19z
dGF0X3JlcGxpY2F0aW9uIDsNCmBgYA0KICANCmFwcGx5IGRlbGF5IHdpbGwg
YmlnIChmZXcgR0IpOw0KDQphbmQgaSBzZWUgdGhlIHN0YW5kYnkncyByZWNv
dmVyeSBwcm9jZXNzIHN0YWNrLCBzb21lIHZlcnkgc2xvdyBjb21tYW4gcHVz
aApvdXQNCmBgYA0KY2xvc2UoeCkNCmNsb3NlKHh4KQ0KY2xvc2UoeHh4KQ0K
Y2xvc2UoeHh4eCkNCmBgYA0KeCBpcyBmZCBudW1iZXIuICAgDQoNCndoeT8N
Cg0KaXQncyBhIGJ1Zz8gb3IgcGVyZm9ybWFuY2UgcHJvYmxlbT8gIA0KDQpi
ZXN0IHJlZ2FyZHMuICANCgoK

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Grigory Smolkin
Дата:
Сообщение: parallel plan in insert query
Следующее
От: Greg Stark
Дата:
Сообщение: Re: parallel plan in insert query