BUG #14246: Postgres crashing frequently
От | amal@guerrillamail.com |
---|---|
Тема | BUG #14246: Postgres crashing frequently |
Дата | |
Msg-id | 20160713082946.1409.98003@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #14246: Postgres crashing frequently
(Kevin Grittner <kgrittn@gmail.com>)
|
Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI0NgpMb2dnZWQgYnk6ICAg ICAgICAgIEFtYWwKRW1haWwgYWRkcmVzczogICAgICBhbWFsQGd1ZXJyaWxs YW1haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS40LjIKT3BlcmF0aW5n IHN5c3RlbTogICBXaW5kb3dzCkRlc2NyaXB0aW9uOiAgICAgICAgCgpQb3N0 Z3JlcyBpcyBjcmFzaGluZyBmcmVxdWVudGx5IGluIHdpbmRvd3Mgc2VydmVy LiBwZ19sb2dzIGFyZSBhcyBmb2xsb3dzLgpUaGVyZSBpcyBjb21pbmcgZGlm ZmVyZW50IHJlYXNvbnMgZm9yIGVhY2ggY3Jhc2hpbmcuIENvdWxkIHlvdSBw bGVhc2UgY2hlY2sKZXZlcnl0aGluZyBhbmQgZ2l2ZSBtZSBzb21lIHNvbHV0 aW9ucyBmb3IgdGhpcyBwcm9ibGVtLg0KX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX18NCkxPRzogIGNvdWxkIG5vdCByZWNlaXZlIGRh dGEgZnJvbSBjbGllbnQ6IE5vIGNvbm5lY3Rpb24gY291bGQgYmUgbWFkZQpi ZWNhdXNlIHRoZSB0YXJnZXQgbWFjaGluZSBhY3RpdmVseSByZWZ1c2VkIGl0 Lg0KCQ0KTE9HOiAgY291bGQgbm90IHJlY2VpdmUgZGF0YSBmcm9tIGNsaWVu dDogTm8gY29ubmVjdGlvbiBjb3VsZCBiZSBtYWRlCmJlY2F1c2UgdGhlIHRh cmdldCBtYWNoaW5lIGFjdGl2ZWx5IHJlZnVzZWQgaXQuDQoNCgkNCldBUk5J Tkc6ICB3b3JrZXIgdG9vayB0b28gbG9uZyB0byBzdGFydDsgY2FuY2VsZWQN CkxPRzogIHNlcnZlciBwcm9jZXNzIChQSUQgMTIzNzEzKSB3YXMgdGVybWlu YXRlZCBieSBleGNlcHRpb24gMHhDMDAwMDE0Mg0KSElOVDogIFNlZSBDIGlu Y2x1ZGUgZmlsZSAibnRzdGF0dXMuaCIgZm9yIGEgZGVzY3JpcHRpb24gb2Yg dGhlIGhleGFkZWNpbWFsCnZhbHVlLg0KTE9HOiAgdGVybWluYXRpbmcgYW55 IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2VzDQpXQVJOSU5HOiAgdGVy bWluYXRpbmcgY29ubmVjdGlvbiBiZWNhdXNlIG9mIGNyYXNoIG9mIGFub3Ro ZXIgc2VydmVyCnByb2Nlc3MNCkRFVEFJTDogIFRoZSBwb3N0bWFzdGVyIGhh cyBjb21tYW5kZWQgdGhpcyBzZXJ2ZXIgcHJvY2VzcyB0byByb2xsIGJhY2sg dGhlCmN1cnJlbnQgdHJhbnNhY3Rpb24gYW5kIGV4aXQsIGJlY2F1c2UgYW5v dGhlciBzZXJ2ZXIgcHJvY2VzcyBleGl0ZWQKYWJub3JtYWxseSBhbmQgcG9z c2libHkgY29ycnVwdGVkIHNoYXJlZCBtZW1vcnkuDQpISU5UOiAgSW4gYSBt b21lbnQgeW91IHNob3VsZCBiZSBhYmxlIHRvIHJlY29ubmVjdCB0byB0aGUg ZGF0YWJhc2UgYW5kCnJlcGVhdCB5b3VyIGNvbW1hbmQuDQpMT0c6ICBhcmNo aXZlciBwcm9jZXNzIChQSUQgNjAxMikgZXhpdGVkIHdpdGggZXhpdCBjb2Rl IDENCkxPRzogIGFsbCBzZXJ2ZXIgcHJvY2Vzc2VzIHRlcm1pbmF0ZWQ7IHJl aW5pdGlhbGl6aW5nDQpGQVRBTDogIHByZS1leGlzdGluZyBzaGFyZWQgbWVt b3J5IGJsb2NrIGlzIHN0aWxsIGluIHVzZQ0KSElOVDogIENoZWNrIGlmIHRo ZXJlIGFyZSBhbnkgb2xkIHNlcnZlciBwcm9jZXNzZXMgc3RpbGwgcnVubmlu ZywgYW5kCnRlcm1pbmF0ZSB0aGVtLg0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVt IHdhcyBpbnRlcnJ1cHRlZDsgbGFzdCBrbm93biB1cCBhdCAyMDE2LTA1LTIz IDEyOjM0OjEyClBTVA0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdhcyBub3Qg cHJvcGVybHkgc2h1dCBkb3duOyBhdXRvbWF0aWMgcmVjb3ZlcnkgaW4KcHJv Z3Jlc3MNCkxPRzogIHJlZG8gc3RhcnRzIGF0IDAvQURFODBFODgNCkZBVEFM OiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzdGFydGluZyB1cA0KRkFUQUw6 ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0aW5nIHVwDQpGQVRBTDog IHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRpbmcgdXANCkZBVEFMOiAg dGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzdGFydGluZyB1cA0KTE9HOiAgcmVj b3JkIHdpdGggemVybyBsZW5ndGggYXQgMC9CMjQyRDdCMA0KTE9HOiAgcmVk byBkb25lIGF0IDAvQjI0MkQ3ODANCkxPRzogIGxhc3QgY29tcGxldGVkIHRy YW5zYWN0aW9uIHdhcyBhdCBsb2cgdGltZSAyMDE2LTA1LTIzCjEyOjM0OjEy LjEyMy0wOA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0 aW5nIHVwDQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRp bmcgdXANCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzdGFydGlu ZyB1cA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0aW5n IHVwDQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRpbmcg dXANCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzdGFydGluZyB1 cA0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIGlzIHJlYWR5IHRvIGFjY2VwdCBj b25uZWN0aW9ucw0KTE9HOiAgYXV0b3ZhY3V1bSBsYXVuY2hlciBzdGFydGVk DQpFUlJPUjogIGRhdGFiYXNlICJmaW5hbmNlIiBhbHJlYWR5IGV4aXN0cw0K U1RBVEVNRU5UOiAgQ1JFQVRFIERBVEFCQVNFICJmaW5hbmNlIg0KTE9HOiAg cmVjZWl2ZWQgZmFzdCBzaHV0ZG93biByZXF1ZXN0DQpMT0c6ICBhYm9ydGlu ZyBhbnkgYWN0aXZlIHRyYW5zYWN0aW9ucw0KRkFUQUw6ICB0ZXJtaW5hdGlu ZyBjb25uZWN0aW9uIGR1ZSB0byBhZG1pbmlzdHJhdG9yIGNvbW1hbmQNCkZB VEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8gYWRtaW5pc3Ry YXRvciBjb21tYW5kDQpMT0c6ICBhdXRvdmFjdXVtIGxhdW5jaGVyIHNodXR0 aW5nIGRvd24NCkxPRzogIHNodXR0aW5nIGRvd24NCkxPRzogIGRhdGFiYXNl IHN5c3RlbSBpcyBzaHV0IGRvd24NCkxPRzogIGRhdGFiYXNlIHN5c3RlbSB3 YXMgc2h1dCBkb3duIGF0IDIwMTYtMDUtMjMgMTc6MjM6NTQgUFNUDQpMT0c6 ICBkYXRhYmFzZSBzeXN0ZW0gaXMgcmVhZHkgdG8gYWNjZXB0IGNvbm5lY3Rp b25zDQpMT0c6ICBhdXRvdmFjdXVtIGxhdW5jaGVyIHN0YXJ0ZWQNCkVSUk9S OiAgZGF0YWJhc2UgImZpbmFuY2UiIGFscmVhZHkgZXhpc3RzDQpTVEFURU1F TlQ6ICBDUkVBVEUgREFUQUJBU0UgImZpbmFuY2UiDQpMT0c6ICBzZXJ2ZXIg cHJvY2VzcyAoUElEIDgzMTAwKSB3YXMgdGVybWluYXRlZCBieSBleGNlcHRp b24gMHhDMDAwMDE0Mg0KSElOVDogIFNlZSBDIGluY2x1ZGUgZmlsZSAibnRz dGF0dXMuaCIgZm9yIGEgZGVzY3JpcHRpb24gb2YgdGhlIGhleGFkZWNpbWFs CnZhbHVlLg0KTE9HOiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBz ZXJ2ZXIgcHJvY2Vzc2VzDQpXQVJOSU5HOiAgdGVybWluYXRpbmcgY29ubmVj dGlvbiBiZWNhdXNlIG9mIGNyYXNoIG9mIGFub3RoZXIgc2VydmVyCnByb2Nl c3MNCkRFVEFJTDogIFRoZSBwb3N0bWFzdGVyIGhhcyBjb21tYW5kZWQgdGhp cyBzZXJ2ZXIgcHJvY2VzcyB0byByb2xsIGJhY2sgdGhlCmN1cnJlbnQgdHJh bnNhY3Rpb24gYW5kIGV4aXQsIGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIgcHJv Y2VzcyBleGl0ZWQKYWJub3JtYWxseSBhbmQgcG9zc2libHkgY29ycnVwdGVk IHNoYXJlZCBtZW1vcnkuDQpISU5UOiAgSW4gYSBtb21lbnQgeW91IHNob3Vs ZCBiZSBhYmxlIHRvIHJlY29ubmVjdCB0byB0aGUgZGF0YWJhc2UgYW5kCnJl cGVhdCB5b3VyIGNvbW1hbmQuDQpXQVJOSU5HOiAgdGVybWluYXRpbmcgY29u bmVjdGlvbiBiZWNhdXNlIG9mIGNyYXNoIG9mIGFub3RoZXIgc2VydmVyCnBy b2Nlc3MNCkRFVEFJTDogIFRoZSBwb3N0bWFzdGVyIGhhcyBjb21tYW5kZWQg dGhpcyBzZXJ2ZXIgcHJvY2VzcyB0byByb2xsIGJhY2sgdGhlCmN1cnJlbnQg dHJhbnNhY3Rpb24gYW5kIGV4aXQsIGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIg cHJvY2VzcyBleGl0ZWQKYWJub3JtYWxseSBhbmQgcG9zc2libHkgY29ycnVw dGVkIHNoYXJlZCBtZW1vcnkuDQpISU5UOiAgSW4gYSBtb21lbnQgeW91IHNo b3VsZCBiZSBhYmxlIHRvIHJlY29ubmVjdCB0byB0aGUgZGF0YWJhc2UgYW5k CnJlcGVhdCB5b3VyIGNvbW1hbmQuDQpMT0c6ICBhcmNoaXZlciBwcm9jZXNz IChQSUQgMTIxMjA0KSBleGl0ZWQgd2l0aCBleGl0IGNvZGUgMQ0KTE9HOiAg YWxsIHNlcnZlciBwcm9jZXNzZXMgdGVybWluYXRlZDsgcmVpbml0aWFsaXpp bmcNCkZBVEFMOiAgcHJlLWV4aXN0aW5nIHNoYXJlZCBtZW1vcnkgYmxvY2sg aXMgc3RpbGwgaW4gdXNlDQpISU5UOiAgQ2hlY2sgaWYgdGhlcmUgYXJlIGFu eSBvbGQgc2VydmVyIHByb2Nlc3NlcyBzdGlsbCBydW5uaW5nLCBhbmQKdGVy bWluYXRlIHRoZW0uDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIGludGVy cnVwdGVkOyBsYXN0IGtub3duIHVwIGF0IDIwMTYtMDUtMjggMTg6MzI6MTgK UFNUDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIG5vdCBwcm9wZXJseSBz aHV0IGRvd247IGF1dG9tYXRpYyByZWNvdmVyeSBpbgpwcm9ncmVzcw0KTE9H OiAgcmVkbyBzdGFydHMgYXQgNC83OTM5ODE4OA0KTE9HOiAgcmVjb3JkIHdp dGggemVybyBsZW5ndGggYXQgNC83OUVFNEUxOA0KTE9HOiAgcmVkbyBkb25l IGF0IDQvNzlFRTRERTgNCkxPRzogIGxhc3QgY29tcGxldGVkIHRyYW5zYWN0 aW9uIHdhcyBhdCBsb2cgdGltZSAyMDE2LTA1LTI4CjE4OjMyOjE4LjE5Ny0w OA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0aW5nIHVw DQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRpbmcgdXAN CkxPRzogIGRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBhY2NlcHQgY29u bmVjdGlvbnMNCkxPRzogIGF1dG92YWN1dW0gbGF1bmNoZXIgc3RhcnRlZA0K RVJST1I6ICBkYXRhYmFzZSAiZmluYW5jZSIgYWxyZWFkeSBleGlzdHMNClNU QVRFTUVOVDogIENSRUFURSBEQVRBQkFTRSAiZmluYW5jZSINCkZBVEFMOiAg Y291bGQgbm90IHJlYXR0YWNoIHRvIHNoYXJlZCBtZW1vcnkgKGtleT0wMDAw MDAwMDAwMDAwMTMwLAphZGRyPTAwMDAwMDAwMDEwMTAwMDApOiBlcnJvciBj b2RlIDE0NTUNCldBUk5JTkc6ICB3b3JrZXIgdG9vayB0b28gbG9uZyB0byBz dGFydDsgY2FuY2VsZWQNCkxPRzogIHNlcnZlciBwcm9jZXNzIChQSUQgMTkx OTExKSB3YXMgdGVybWluYXRlZCBieSBleGNlcHRpb24gMHhDMDAwMDEyRA0K SElOVDogIFNlZSBDIGluY2x1ZGUgZmlsZSAibnRzdGF0dXMuaCIgZm9yIGEg ZGVzY3JpcHRpb24gb2YgdGhlIGhleGFkZWNpbWFsCnZhbHVlLg0KTE9HOiAg dGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2ZXIgcHJvY2Vzc2Vz DQpXQVJOSU5HOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBiZWNhdXNlIG9m IGNyYXNoIG9mIGFub3RoZXIgc2VydmVyCnByb2Nlc3MNCkRFVEFJTDogIFRo ZSBwb3N0bWFzdGVyIGhhcyBjb21tYW5kZWQgdGhpcyBzZXJ2ZXIgcHJvY2Vz cyB0byByb2xsIGJhY2sgdGhlCmN1cnJlbnQgdHJhbnNhY3Rpb24gYW5kIGV4 aXQsIGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIgcHJvY2VzcyBleGl0ZWQKYWJu b3JtYWxseSBhbmQgcG9zc2libHkgY29ycnVwdGVkIHNoYXJlZCBtZW1vcnku DQpISU5UOiAgSW4gYSBtb21lbnQgeW91IHNob3VsZCBiZSBhYmxlIHRvIHJl Y29ubmVjdCB0byB0aGUgZGF0YWJhc2UgYW5kCnJlcGVhdCB5b3VyIGNvbW1h bmQuDQpMT0c6ICBhcmNoaXZlciBwcm9jZXNzIChQSUQgMTQ0MTk0KSBleGl0 ZWQgd2l0aCBleGl0IGNvZGUgMQ0KTE9HOiAgYWxsIHNlcnZlciBwcm9jZXNz ZXMgdGVybWluYXRlZDsgcmVpbml0aWFsaXppbmcNCkZBVEFMOiAgY291bGQg bm90IGNyZWF0ZSBzaGFyZWQgbWVtb3J5IHNlZ21lbnQ6IGVycm9yIGNvZGUg MTQ1NQ0KREVUQUlMOiAgRmFpbGVkIHN5c3RlbSBjYWxsIHdhcyBDcmVhdGVG aWxlTWFwcGluZyhzaXplPTEyMDE5MzA0MCwKbmFtZT1HbG9iYWwvUG9zdGdy ZVNRTDpFOi9maW5hbmNlL3Bnc3FsL2RhdGEpLg0KTE9HOiAgZGF0YWJhc2Ug c3lzdGVtIHdhcyBpbnRlcnJ1cHRlZDsgbGFzdCBrbm93biB1cCBhdCAyMDE2 LTA1LTI4IDIwOjAyOjAwClBTVA0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIHdh cyBub3QgcHJvcGVybHkgc2h1dCBkb3duOyBhdXRvbWF0aWMgcmVjb3Zlcnkg aW4KcHJvZ3Jlc3MNCkxPRzogIHJlZG8gc3RhcnRzIGF0IDQvN0JBRjM2NzgN CkxPRzogIHJlY29yZCB3aXRoIHplcm8gbGVuZ3RoIGF0IDQvN0Q2RTg5MTgN CkxPRzogIHJlZG8gZG9uZSBhdCA0LzdENkU4OEU4DQpMT0c6ICBsYXN0IGNv bXBsZXRlZCB0cmFuc2FjdGlvbiB3YXMgYXQgbG9nIHRpbWUgMjAxNi0wNS0y OAoyMDowMjowMC4xMDItMDgNCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3Rl bSBpcyBzdGFydGluZyB1cA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVt IGlzIHN0YXJ0aW5nIHVwDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gaXMgcmVh ZHkgdG8gYWNjZXB0IGNvbm5lY3Rpb25zDQpMT0c6ICBhdXRvdmFjdXVtIGxh dW5jaGVyIHN0YXJ0ZWQNCkVSUk9SOiAgZGF0YWJhc2UgImZpbmFuY2UiIGFs cmVhZHkgZXhpc3RzDQpTVEFURU1FTlQ6ICBDUkVBVEUgREFUQUJBU0UgImZp bmFuY2UiDQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8gc3Rh cnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgYXV0b3ZhY3V1bSB3b3JrZXIgc3Rh cnRlZCB3aXRob3V0IGEgd29ya2VyIGVudHJ5DQpMT0c6ICBzZXJ2ZXIgcHJv Y2VzcyAoUElEIDM4NzU2KSB3YXMgdGVybWluYXRlZCBieSBleGNlcHRpb24g MHhDMDAwMDE0Mg0KSElOVDogIFNlZSBDIGluY2x1ZGUgZmlsZSAibnRzdGF0 dXMuaCIgZm9yIGEgZGVzY3JpcHRpb24gb2YgdGhlIGhleGFkZWNpbWFsCnZh bHVlLg0KTE9HOiAgdGVybWluYXRpbmcgYW55IG90aGVyIGFjdGl2ZSBzZXJ2 ZXIgcHJvY2Vzc2VzDQpXQVJOSU5HOiAgdGVybWluYXRpbmcgY29ubmVjdGlv biBiZWNhdXNlIG9mIGNyYXNoIG9mIGFub3RoZXIgc2VydmVyCnByb2Nlc3MN CkRFVEFJTDogIFRoZSBwb3N0bWFzdGVyIGhhcyBjb21tYW5kZWQgdGhpcyBz ZXJ2ZXIgcHJvY2VzcyB0byByb2xsIGJhY2sgdGhlCmN1cnJlbnQgdHJhbnNh Y3Rpb24gYW5kIGV4aXQsIGJlY2F1c2UgYW5vdGhlciBzZXJ2ZXIgcHJvY2Vz cyBleGl0ZWQKYWJub3JtYWxseSBhbmQgcG9zc2libHkgY29ycnVwdGVkIHNo YXJlZCBtZW1vcnkuDQpISU5UOiAgSW4gYSBtb21lbnQgeW91IHNob3VsZCBi ZSBhYmxlIHRvIHJlY29ubmVjdCB0byB0aGUgZGF0YWJhc2UgYW5kCnJlcGVh dCB5b3VyIGNvbW1hbmQuDQpMT0c6ICBhcmNoaXZlciBwcm9jZXNzIChQSUQg OTkxOSkgZXhpdGVkIHdpdGggZXhpdCBjb2RlIDENCkxPRzogIGFsbCBzZXJ2 ZXIgcHJvY2Vzc2VzIHRlcm1pbmF0ZWQ7IHJlaW5pdGlhbGl6aW5nDQpGQVRB TDogIHByZS1leGlzdGluZyBzaGFyZWQgbWVtb3J5IGJsb2NrIGlzIHN0aWxs IGluIHVzZQ0KSElOVDogIENoZWNrIGlmIHRoZXJlIGFyZSBhbnkgb2xkIHNl cnZlciBwcm9jZXNzZXMgc3RpbGwgcnVubmluZywgYW5kCnRlcm1pbmF0ZSB0 aGVtLg0KDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIGludGVycnVwdGVk OyBsYXN0IGtub3duIHVwIGF0IDIwMTYtMDUtMjkgMDc6MTU6MzIKUFNUDQpM T0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2FzIG5vdCBwcm9wZXJseSBzaHV0IGRv d247IGF1dG9tYXRpYyByZWNvdmVyeSBpbgpwcm9ncmVzcw0KTE9HOiAgcmVk byBzdGFydHMgYXQgNS8zNjY4NTNBOA0KTE9HOiAgcmVjb3JkIHdpdGggemVy byBsZW5ndGggYXQgNS8zNzkxMTQwMA0KTE9HOiAgcmVkbyBkb25lIGF0IDUv Mzc5MTEzRDANCkxPRzogIGxhc3QgY29tcGxldGVkIHRyYW5zYWN0aW9uIHdh cyBhdCBsb2cgdGltZSAyMDE2LTA1LTI5CjA3OjE1OjMyLjE4OC0wOA0KRkFU QUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0aW5nIHVwDQpMT0c6 ICBkYXRhYmFzZSBzeXN0ZW0gaXMgcmVhZHkgdG8gYWNjZXB0IGNvbm5lY3Rp b25zDQpMT0c6ICBhdXRvdmFjdXVtIGxhdW5jaGVyIHN0YXJ0ZWQNCkVSUk9S OiAgZGF0YWJhc2UgImZpbmFuY2UiIGFscmVhZHkgZXhpc3RzDQpTVEFURU1F TlQ6ICBDUkVBVEUgREFUQUJBU0UgImZpbmFuY2UiDQpGQVRBTDogIGNvdWxk IG5vdCByZWF0dGFjaCB0byBzaGFyZWQgbWVtb3J5IChrZXk9MDAwMDAwMDAw MDAwMDEzMCwKYWRkcj0wMDAwMDAwMDAxRjEwMDAwKTogZXJyb3IgY29kZSAx NDU1DQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8gc3RhcnQ7 IGNhbmNlbGVkDQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8g c3RhcnQ7IGNhbmNlbGVkDQpFUlJPUjogIGNvdWxkIG5vdCB3cml0ZSBibG9j ayAyNzUxIGluIGZpbGUgImJhc2UvMTYzODQvMTUzMjA0IjogTm90IGVub3Vn aApzcGFjZQ0KQ09OVEVYVDogIHdyaXRpbmcgYmxvY2sgMjc1MSBvZiByZWxh dGlvbiBiYXNlLzE2Mzg0LzE1MzIwNA0KTE9HOiAgY291bGQgbm90IHJlY2Vp dmUgZGF0YSBmcm9tIGNsaWVudDogTm8gY29ubmVjdGlvbiBjb3VsZCBiZSBt YWRlCmJlY2F1c2UgdGhlIHRhcmdldCBtYWNoaW5lIGFjdGl2ZWx5IHJlZnVz ZWQgaXQuDQoNCgkNCkxPRzogIGNvdWxkIG5vdCByZWNlaXZlIGRhdGEgZnJv bSBjbGllbnQ6IE5vIGNvbm5lY3Rpb24gY291bGQgYmUgbWFkZQpiZWNhdXNl IHRoZSB0YXJnZXQgbWFjaGluZSBhY3RpdmVseSByZWZ1c2VkIGl0Lg0KDQoJ DQpMT0c6ICBjb3VsZCBub3QgcmVjZWl2ZSBkYXRhIGZyb20gY2xpZW50OiBO byBjb25uZWN0aW9uIGNvdWxkIGJlIG1hZGUKYmVjYXVzZSB0aGUgdGFyZ2V0 IG1hY2hpbmUgYWN0aXZlbHkgcmVmdXNlZCBpdC4NCg0KCQ0KTE9HOiAgY291 bGQgbm90IHJlY2VpdmUgZGF0YSBmcm9tIGNsaWVudDogTm8gY29ubmVjdGlv biBjb3VsZCBiZSBtYWRlCmJlY2F1c2UgdGhlIHRhcmdldCBtYWNoaW5lIGFj dGl2ZWx5IHJlZnVzZWQgaXQuDQoNCgkNCkxPRzogIGluY29tcGxldGUgc3Rh cnR1cCBwYWNrZXQNCkxPRzogIGNvdWxkIG5vdCByZWNlaXZlIGRhdGEgZnJv bSBjbGllbnQ6IE5vIGNvbm5lY3Rpb24gY291bGQgYmUgbWFkZQpiZWNhdXNl IHRoZSB0YXJnZXQgbWFjaGluZSBhY3RpdmVseSByZWZ1c2VkIGl0Lg0KDQoJ DQpMT0c6ICByZWNlaXZlZCBmYXN0IHNodXRkb3duIHJlcXVlc3QNCkxPRzog IGFib3J0aW5nIGFueSBhY3RpdmUgdHJhbnNhY3Rpb25zDQpMT0c6ICBkYXRh YmFzZSBzeXN0ZW0gd2FzIGludGVycnVwdGVkOyBsYXN0IGtub3duIHVwIGF0 IDIwMTYtMDUtMzAgMTI6NTI6MTIKUFNUDQpMT0c6ICBkYXRhYmFzZSBzeXN0 ZW0gd2FzIG5vdCBwcm9wZXJseSBzaHV0IGRvd247IGF1dG9tYXRpYyByZWNv dmVyeSBpbgpwcm9ncmVzcw0KTE9HOiAgcmVkbyBzdGFydHMgYXQgNS80Mzcx MEQwOA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0aW5n IHVwDQpMT0c6ICB1bmV4cGVjdGVkIHBhZ2VhZGRyIDUvM0E1RjYwMDAgaW4g bG9nIGZpbGUgNSwgc2VnbWVudCA3MSwgb2Zmc2V0CjYyNTA0OTYNCkxPRzog IHJlZG8gZG9uZSBhdCA1LzQ3NUYyRjAwDQpMT0c6ICBsYXN0IGNvbXBsZXRl ZCB0cmFuc2FjdGlvbiB3YXMgYXQgbG9nIHRpbWUgMjAxNi0wNS0zMAoxMjo1 MjoxMi4wMTkrMDINCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBz dGFydGluZyB1cA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0 YXJ0aW5nIHVwDQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3Rh cnRpbmcgdXANCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzdGFy dGluZyB1cA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHN0YXJ0 aW5nIHVwDQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc3RhcnRp bmcgdXANCkxPRzogIGRhdGFiYXNlIHN5c3RlbSBpcyByZWFkeSB0byBhY2Nl cHQgY29ubmVjdGlvbnMNCkxPRzogIGF1dG92YWN1dW0gbGF1bmNoZXIgc3Rh cnRlZA0KRVJST1I6ICBkYXRhYmFzZSAiZmluYW5jZSIgYWxyZWFkeSBleGlz dHMNClNUQVRFTUVOVDogIENSRUFURSBEQVRBQkFTRSAiZmluYW5jZSINCkxP RzogIHNlcnZlciBwcm9jZXNzIChQSUQgNDA4OTIpIHdhcyB0ZXJtaW5hdGVk IGJ5IGV4Y2VwdGlvbiAweEMwMDAwMTQyDQpISU5UOiAgU2VlIEMgaW5jbHVk ZSBmaWxlICJudHN0YXR1cy5oIiBmb3IgYSBkZXNjcmlwdGlvbiBvZiB0aGUg aGV4YWRlY2ltYWwKdmFsdWUuDQpMT0c6ICB0ZXJtaW5hdGluZyBhbnkgb3Ro ZXIgYWN0aXZlIHNlcnZlciBwcm9jZXNzZXMNCldBUk5JTkc6ICB3b3JrZXIg dG9vayB0b28gbG9uZyB0byBzdGFydDsgY2FuY2VsZWQNCldBUk5JTkc6ICB0 ZXJtaW5hdGluZyBjb25uZWN0aW9uIGJlY2F1c2Ugb2YgY3Jhc2ggb2YgYW5v dGhlciBzZXJ2ZXIKcHJvY2Vzcw0KREVUQUlMOiAgVGhlIHBvc3RtYXN0ZXIg aGFzIGNvbW1hbmRlZCB0aGlzIHNlcnZlciBwcm9jZXNzIHRvIHJvbGwgYmFj ayB0aGUKY3VycmVudCB0cmFuc2FjdGlvbiBhbmQgZXhpdCwgYmVjYXVzZSBh bm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZAphYm5vcm1hbGx5IGFuZCBw b3NzaWJseSBjb3JydXB0ZWQgc2hhcmVkIG1lbW9yeS4NCkhJTlQ6ICBJbiBh IG1vbWVudCB5b3Ugc2hvdWxkIGJlIGFibGUgdG8gcmVjb25uZWN0IHRvIHRo ZSBkYXRhYmFzZSBhbmQKcmVwZWF0IHlvdXIgY29tbWFuZC4NCldBUk5JTkc6 ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9uIGJlY2F1c2Ugb2YgY3Jhc2ggb2Yg YW5vdGhlciBzZXJ2ZXIKcHJvY2Vzcw0KREVUQUlMOiAgVGhlIHBvc3RtYXN0 ZXIgaGFzIGNvbW1hbmRlZCB0aGlzIHNlcnZlciBwcm9jZXNzIHRvIHJvbGwg YmFjayB0aGUKY3VycmVudCB0cmFuc2FjdGlvbiBhbmQgZXhpdCwgYmVjYXVz ZSBhbm90aGVyIHNlcnZlciBwcm9jZXNzIGV4aXRlZAphYm5vcm1hbGx5IGFu ZCBwb3NzaWJseSBjb3JydXB0ZWQgc2hhcmVkIG1lbW9yeS4NCkhJTlQ6ICBJ biBhIG1vbWVudCB5b3Ugc2hvdWxkIGJlIGFibGUgdG8gcmVjb25uZWN0IHRv IHRoZSBkYXRhYmFzZSBhbmQKcmVwZWF0IHlvdXIgY29tbWFuZC4NCkxPRzog IGFyY2hpdmVyIHByb2Nlc3MgKFBJRCAyNjE2KSBleGl0ZWQgd2l0aCBleGl0 IGNvZGUgMQ0KTE9HOiAgYWxsIHNlcnZlciBwcm9jZXNzZXMgdGVybWluYXRl ZDsgcmVpbml0aWFsaXppbmcNCkZBVEFMOiAgcHJlLWV4aXN0aW5nIHNoYXJl ZCBtZW1vcnkgYmxvY2sgaXMgc3RpbGwgaW4gdXNlDQpISU5UOiAgQ2hlY2sg aWYgdGhlcmUgYXJlIGFueSBvbGQgc2VydmVyIHByb2Nlc3NlcyBzdGlsbCBy dW5uaW5nLCBhbmQKdGVybWluYXRlIHRoZW0uDQpMT0c6ICBkYXRhYmFzZSBz eXN0ZW0gd2FzIGludGVycnVwdGVkOyBsYXN0IGtub3duIHVwIGF0IDIwMTYt MDYtMDEgMDY6MTI6MjIKUFNUDQpMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gd2Fz IG5vdCBwcm9wZXJseSBzaHV0IGRvd247IGF1dG9tYXRpYyByZWNvdmVyeSBp bgpwcm9ncmVzcw0KTE9HOiAgcmVkbyBzdGFydHMgYXQgNi9FRkNBREU4DQpM T0c6ICByZWNvcmQgd2l0aCB6ZXJvIGxlbmd0aCBhdCA2LzExODE3NzY4DQpM T0c6ICByZWRvIGRvbmUgYXQgNi8xMTgxNzczOA0KTE9HOiAgbGFzdCBjb21w bGV0ZWQgdHJhbnNhY3Rpb24gd2FzIGF0IGxvZyB0aW1lIDIwMTYtMDYtMDEK MDY6MTI6MjIuMTYxLTA4DQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0g aXMgc3RhcnRpbmcgdXANCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBp cyBzdGFydGluZyB1cA0KRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlz IHN0YXJ0aW5nIHVwDQpGQVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMg c3RhcnRpbmcgdXANCkZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBz dGFydGluZyB1cA0KTE9HOiAgZGF0YWJhc2Ugc3lzdGVtIGlzIHJlYWR5IHRv IGFjY2VwdCBjb25uZWN0aW9ucw0KTE9HOiAgYXV0b3ZhY3V1bSBsYXVuY2hl ciBzdGFydGVkDQpFUlJPUjogIGRhdGFiYXNlICJmaW5hbmNlIiBhbHJlYWR5 IGV4aXN0cw0KU1RBVEVNRU5UOiAgQ1JFQVRFIERBVEFCQVNFICJmaW5hbmNl Ig0KTE9HOiAgdW5yZWNvZ25pemVkIHdpbjMyIGVycm9yIGNvZGU6IDE0NTAN CkxPRzogIGNvdWxkIG5vdCBvcGVuIHRlbXBvcmFyeSBzdGF0aXN0aWNzIGZp bGUgInBnX3N0YXRfdG1wL3Bnc3RhdC50bXAiOgpJbnZhbGlkIGFyZ3VtZW50 DQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8gc3RhcnQ7IGNh bmNlbGVkDQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8gc3Rh cnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcg dG8gc3RhcnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9v IGxvbmcgdG8gc3RhcnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgd29ya2VyIHRv b2sgdG9vIGxvbmcgdG8gc3RhcnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgYXV0 b3ZhY3V1bSB3b3JrZXIgc3RhcnRlZCB3aXRob3V0IGEgd29ya2VyIGVudHJ5 DQpXQVJOSU5HOiAgYXV0b3ZhY3V1bSB3b3JrZXIgc3RhcnRlZCB3aXRob3V0 IGEgd29ya2VyIGVudHJ5DQpXQVJOSU5HOiAgYXV0b3ZhY3V1bSB3b3JrZXIg c3RhcnRlZCB3aXRob3V0IGEgd29ya2VyIGVudHJ5DQpXQVJOSU5HOiAgd29y a2VyIHRvb2sgdG9vIGxvbmcgdG8gc3RhcnQ7IGNhbmNlbGVkDQpXQVJOSU5H OiAgYXV0b3ZhY3V1bSB3b3JrZXIgc3RhcnRlZCB3aXRob3V0IGEgd29ya2Vy IGVudHJ5DQpXQVJOSU5HOiAgd29ya2VyIHRvb2sgdG9vIGxvbmcgdG8gc3Rh cnQ7IGNhbmNlbGVkDQpXQVJOSU5HOiAgYXV0b3ZhY3V1bSB3b3JrZXIgc3Rh cnRlZCB3aXRob3V0IGEgd29ya2VyIGVudHJ5DQpMT0c6ICBzZXJ2ZXIgcHJv Y2VzcyAoUElEIDE0MTE5MCkgd2FzIHRlcm1pbmF0ZWQgYnkgZXhjZXB0aW9u IDB4QzAwMDAxNDINCkhJTlQ6ICBTZWUgQyBpbmNsdWRlIGZpbGUgIm50c3Rh dHVzLmgiIGZvciBhIGRlc2NyaXB0aW9uIG9mIHRoZSBoZXhhZGVjaW1hbAp2 YWx1ZS4NCkxPRzogIHRlcm1pbmF0aW5nIGFueSBvdGhlciBhY3RpdmUgc2Vy dmVyIHByb2Nlc3Nlcw0KV0FSTklORzogIHRlcm1pbmF0aW5nIGNvbm5lY3Rp b24gYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNlcnZlcgpwcm9jZXNz DQpERVRBSUw6ICBUaGUgcG9zdG1hc3RlciBoYXMgY29tbWFuZGVkIHRoaXMg c2VydmVyIHByb2Nlc3MgdG8gcm9sbCBiYWNrIHRoZQpjdXJyZW50IHRyYW5z YWN0aW9uIGFuZCBleGl0LCBiZWNhdXNlIGFub3RoZXIgc2VydmVyIHByb2Nl c3MgZXhpdGVkCmFibm9ybWFsbHkgYW5kIHBvc3NpYmx5IGNvcnJ1cHRlZCBz aGFyZWQgbWVtb3J5Lg0KSElOVDogIEluIGEgbW9tZW50IHlvdSBzaG91bGQg YmUgYWJsZSB0byByZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZApyZXBl YXQgeW91ciBjb21tYW5kLg0KV0FSTklORzogIHRlcm1pbmF0aW5nIGNvbm5l Y3Rpb24gYmVjYXVzZSBvZiBjcmFzaCBvZiBhbm90aGVyIHNlcnZlcgpwcm9j ZXNzDQpERVRBSUw6ICBUaGUgcG9zdG1hc3RlciBoYXMgY29tbWFuZGVkIHRo aXMgc2VydmVyIHByb2Nlc3MgdG8gcm9sbCBiYWNrIHRoZQpjdXJyZW50IHRy YW5zYWN0aW9uIGFuZCBleGl0LCBiZWNhdXNlIGFub3RoZXIgc2VydmVyIHBy b2Nlc3MgZXhpdGVkCmFibm9ybWFsbHkgYW5kIHBvc3NpYmx5IGNvcnJ1cHRl ZCBzaGFyZWQgbWVtb3J5Lg0KSElOVDogIEluIGEgbW9tZW50IHlvdSBzaG91 bGQgYmUgYWJsZSB0byByZWNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlIGFuZApy ZXBlYXQgeW91ciBjb21tYW5kLg0KTE9HOiAgYXJjaGl2ZXIgcHJvY2VzcyAo UElEIDE5MDAwMSkgZXhpdGVkIHdpdGggZXhpdCBjb2RlIDENCkxPRzogIGFs bCBzZXJ2ZXIgcHJvY2Vzc2VzIHRlcm1pbmF0ZWQ7IHJlaW5pdGlhbGl6aW5n DQpGQVRBTDogIHByZS1leGlzdGluZyBzaGFyZWQgbWVtb3J5IGJsb2NrIGlz IHN0aWxsIGluIHVzZQ0KSElOVDogIENoZWNrIGlmIHRoZXJlIGFyZSBhbnkg b2xkIHNlcnZlciBwcm9jZXNzZXMgc3RpbGwgcnVubmluZywgYW5kCnRlcm1p bmF0ZSB0aGVtLg0KCgo=
В списке pgsql-bugs по дате отправления:
Следующее
От: David WallerДата:
Сообщение: Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created