Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts

Поиск
Список
Период
Сортировка
От Paul
Тема Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts
Дата
Msg-id 568d8e74.d1a9ca0a.d9558.ffff9026@mx.google.com
обсуждение исходный текст
Ответ на Re: BUG #13846: INSERT ON CONFLICT consumes sequencers onconflicts  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-bugs
Дерево обсуждения 
SeKAmW0gbG9va2luZyBhdCBtYXRoIG1vcmUgbGlrZSBhIHNpbmdsZSBGYWN0IHRhYmxlIGhhdmlu
ZyAgNTAwIG1pbGxpb24gcmVjb3Jkcywgd2l0aCAxMCBkaW1lbnNpb24gY29sdW1ucy4gSWYgSU5U
cyB3ZXJlIHVzZWQgZm9yIHRoZSBkaW1lbnNpb24gY29sdW1ucywgdGhhdOKAmXMgMjBHQi4gSWYg
SSBoYWQgdG8gY2hhbmdlIHRob3NlIGRpbWVuc2lvbiBjb2x1bW5zIHRvIEJJR0lOVHMsIHRoYXTi
gJlzIDQwR0IuIFRoaXMgY2FuIGltcGFjdCBob3cgbXVjaCB5b3UgY2FuIGZpdCBpbnRvIHNlcnZl
ciBtZW1vcnksIHdoZXJlIG9sYXBzIGxpa2UgdG8gbGl2ZSwgYW5kIGp1c3Qgc2xvdyBkb3duIG1v
dmluZyBzdHVmZiBhcm91bmQgYmV0d2VlbiBtZW1vcnkgYW5kIGRpc2sgYW5kIG92ZXIgdGhlIG5l
dHdvcmsgYW5kIGJhY2t1cHMsIGV0Yy4NCg0KT24gYSB0ZWNobmljYWwgbm90ZSwgd2h5IGlzIHRo
ZSBmb2xsb3dpbmcgZmxvdyBjb25zaWRlcmVkIOKAmGZyYWdpbGXigJk/DQoxKSBFdmFsdWF0ZSBv
bmx5IGNvbHVtbnMgdXNlZCBpbiBjb25mbGljdF90YXJnZXQNCmEuIENvbmZsaWN0LXJlc29sdmlu
ZyBDb2x1bW5zIHdpdGggZGVmYXVsdCBuZXh0dmFsKCkgaW5jcmVtZW50IHRoZSBjb3JyZXNwb25k
aW5nIHNlcXVlbmNlcg0KaS4gQW5kIGluIHRoaXMgY2FzZSwgdGhlcmUgd2VyZSBuZXZlciBiZSBj
b25mbGljdHMgYnkgZGVmaW5pdGlvbiwgc28gT04gQ09ORkxJQ1QgY2FuIGFsd2F5cyBiZSBpZ25v
cmVkDQoyKSBJZiBjb25mbGljdCwgRE8gVVBEQVRFDQphLiBJZiBuZXh0dmFsKCktZGVmYXVsdGVk
IGNvbHVtbiB1c2VkIGluIGNvbmZsaWN0X3RhcmdldCwgd2UgbmV2ZXIgZ2V0IGhlcmUNCmIuIERl
ZmF1bHRzIG5ldmVyIGV2YWx1YXRlZA0KMykgRWxzZSBFdmFsdWF0ZSByZW1haW5pbmcgY29sdW1u
cyBub3QgdXNlZCBpbiBjb25mbGljdF90YXJnZXQgYW5kIElOU0VSVA0KYS4gQ29sdW1ucyB3aXRo
IG5leHR2YWwoKSBpbmNyZW1lbnQgdGhlaXIgY29ycmVzcG9uZGluZyBzZXF1ZW5jZXINCg0KDQoN
Cg0KDQpGcm9tOiBQZXRlciBHZW9naGVnYW4NClNlbnQ6IFdlZG5lc2RheSwgSmFudWFyeSA2LCAy
MDE2IDI6MTMgUE0NClRvOiBQYXVsDQpDYzogQW5kcmVzIEZyZXVuZDsgcGdzcWwtYnVncw0KU3Vi
amVjdDogUmU6IFtCVUdTXSBCVUcgIzEzODQ2OiBJTlNFUlQgT04gQ09ORkxJQ1QgY29uc3VtZXMg
c2VxdWVuY2Vyc29uY29uZmxpY3RzDQoNCk9uIFdlZCwgSmFuIDYsIDIwMTYgYXQgMTowMCBQTSwg
UGF1bCA8cGF1bEBzYWxlc2ludGVsLmNvbT4gd3JvdGU6DQo+IE15IG9ubHkgcG9pbnQgaXMsIHRo
ZXJl4oCZcyBhbm90aGVyIGdyZWF0IGNhcGFiaWxpdHkgaW4gUG9zdGdyZXMsIGZvciBkb2luZw0K
PiBlZmZpY2llbnQgY29uY3VycmVudCBVUFNFUlRTLCBidXQgdGhhdCBvbmUgb2YgdGhlIG1vc3Qg
Y29tbW9uIGFuZCBwcmltZSB1c2UNCj4gY2FzZXMgZm9yIGl0IGlzIGdvaW5nIHRvIGNvc3QgbW9y
ZSBtb25leSBmcm9tIGhhdmluZyB0byB1c2UgNjRiaXQgbnVtYmVycw0KPiBldmVyeXdoZXJlIGZv
ciBubyBnb29kIHJlYXNvbi4NCg0KTm90IHJlYWxseTsgYXQgbGVhc3QsIGl0IHdvbid0IGluY3Jl
YXNlIHRoZSBzaXplIG9mIGEgcGxhaW4gQklHU0VSSUFMDQpwcmltYXJ5IGtleSBpbmRleCAod2hp
Y2ggd2lsbCBnZW5lcmFsbHkgbm90IGJlIGNvbXBvc2l0ZSk6DQoNCnBvc3RncmVzPSMgY3JlYXRl
IHRhYmxlIGZvbyBhcyBzZWxlY3QgKHJhbmRvbSgpICogMTAwMDAwMDAwKTo6aW50NA0KcGtleSBm
cm9tIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwMDApOw0KU0VMRUNUIDEwMDAwMA0KcG9zdGdyZXM9
IyBjcmVhdGUgaW5kZXggb24gZm9vIChwa2V5KTsNCkNSRUFURSBJTkRFWA0KDQpwb3N0Z3Jlcz0j
IFxkdCsgZm9vDQogICAgICAgICAgICAgICAgICAgTGlzdCBvZiByZWxhdGlvbnMNCiBTY2hlbWEg
4pSCIE5hbWUg4pSCIFR5cGUgIOKUgiBPd25lciDilIIgIFNpemUgICDilIIgRGVzY3JpcHRpb24N
CuKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKU
gOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKU
gOKUgOKUgOKUgOKUvOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgOKUgA0KIHB1
YmxpYyDilIIgZm9vICDilIIgdGFibGUg4pSCIHBnICAgIOKUgiAzNTQ0IGtCIOKUgg0KKDEgcm93
KQ0KDQpwb3N0Z3Jlcz0jIFxkaSsgZm9vX3BrZXlfaWR4DQogICAgICAgICAgICAgICAgICAgICAg
ICAgICBMaXN0IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSDilIIgICAgIE5hbWUgICAgIOKUgiBUeXBl
ICDilIIgT3duZXIg4pSCIFRhYmxlIOKUgiAgU2l6ZSAgIOKUgiBEZXNjcmlwdGlvbg0K4pSA4pSA
4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA
4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS8
4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pS84pSA
4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSA4pSADQogcHVibGljIOKUgiBmb29fcGtl
eV9pZHgg4pSCIGluZGV4IOKUgiBwZyAgICDilIIgZm9vICAg4pSCIDIyMDgga0Ig4pSCDQooMSBy
b3cpDQoNCnBvc3RncmVzPSMgYWx0ZXIgdGFibGUgZm9vIGFsdGVyIGNvbHVtbiBwa2V5IHR5cGUg
aW50ODsNCkFMVEVSIFRBQkxFDQoNCnBvc3RncmVzPSMgXGRpKyBmb29fcGtleV9pZHgNCiAgICAg
ICAgICAgICAgICAgICAgICAgICAgIExpc3Qgb2YgcmVsYXRpb25zDQogU2NoZW1hIOKUgiAgICAg
TmFtZSAgICAg4pSCIFR5cGUgIOKUgiBPd25lciDilIIgVGFibGUg4pSCICBTaXplICAg4pSCIERl
c2NyaXB0aW9uDQrilIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDi
lIDilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDi
lIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilLzilIDilIDilIDilIDilIDi
lIDilIDilIDilIDilLzilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIDilIANCiBw
dWJsaWMg4pSCIGZvb19wa2V5X2lkeCDilIIgaW5kZXgg4pSCIHBnICAgIOKUgiBmb28gICDilIIg
MjIwOCBrQiDilIINCigxIHJvdykNCg0KVGhlIHVuY2hhbmdlZCBzaXplIG9mIHRoZSBpbmRleCBm
b29fcGtleV9pZHggc2VlbiBoZXJlIGR1ZSB0bw0KYWxpZ25tZW50IGNvbnNpZGVyYXRpb25zLiBH
cmFudGVkLCB0aGUgaGVhcCBtaWdodCBzdGlsbCBiZSBhIGJpdA0KbGFyZ2VyIHRoYW4gaXQgd291
bGQgb3RoZXJ3aXNlIGJlLCBiZWNhdXNlIGl0IHdpbGwgdXN1YWxseSBiZQ0KImNvbXBvc2l0ZSIs
IGJ1dCBJIHRoaW5rIHRoZSAiY29zdCIgb2YgeW91ciB1c2luZyBpbnQ4IHdpbGwgbm90IGJyZWFr
DQp0aGUgYmFuay4NCg0KLS0gDQpQZXRlciBHZW9naGVnYW4NCg0K

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

Предыдущее
От: Paul
Дата:
Сообщение: Re: BUG #13846: INSERT ON CONFLICT consumes sequencersonconflicts
Следующее
От: Navaneethakrishnan Gopal
Дата:
Сообщение: Re: BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM