BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created

Поиск
Список
Период
Сортировка
От dwaller@microsoft.com
Тема BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created
Дата
Msg-id 20160708102407.1409.87848@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzNwpMb2dnZWQgYnk6ICAg
ICAgICAgIERhdmlkIFdhbGxlcgpFbWFpbCBhZGRyZXNzOiAgICAgIGR3YWxs
ZXJAbWljcm9zb2Z0LmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuMy43Ck9w
ZXJhdGluZyBzeXN0ZW06ICAgTGludXggKFVidW50dSkKRGVzY3JpcHRpb246
ICAgICAgICAKClN1bW1hcnk6IFdoaWxlIHJ1bm5pbmcg4oCYY3JlYXRlIGlu
ZGV4IGNvbmN1cnJlbnRseeKAmSBvbiBhIHZlcnkgbGFyZ2UgdGFibGUsCnJ1
bm5pbmcg4oCYZHJvcCBpbmRleOKAmSBmb3IgdGhlIHNhbWUgaW5kZXggY2F1
c2VkIFBvc3RncmVzIHRvIHBlcmZvcm0gdGVycmlibHkKYmFkbHksIHVudGls
IHRoZSDigJhjcmVhdGUgaW5kZXjigJkgc2VydmVyIHByb2Nlc3Mgd2FzIGtp
bGxlZC4gIEkgd291bGQgZXhwZWN0CnRoYXQgdGhlIOKAmGRyb3AgaW5kZXji
gJkgd291bGQgZWl0aGVyIGZhaWwgaW1tZWRpYXRlbHksIG9yIHdhaXQsIHdp
dGhvdXQKcGVyZm9ybWFuY2UgaW1wYWN0LCB1bnRpbCB0aGUg4oCYY3JlYXRl
IGluZGV4IGNvbmN1cnJlbnRseeKAmSBoYWQgY29tcGxldGVkLg0KDQpJbiBk
ZXRhaWw6DQoNCkkgc3RhcnRlZCBhZGRpbmcgYW4gaW5kZXggdG8gYSBsYXJn
ZSB0YWJsZSB1c2luZyAnY3JlYXRlIGluZGV4IGNvbmN1cnJlbnRseQouLi4n
ICAoSSB3YXMgcnVubmluZyB0aGUgY29tbWFuZCB1c2luZyBhIFJhaWxzIG1p
Z3JhdGlvbiwgY29ubmVjdGluZyB0bwpQb3N0Z3JlcyByZW1vdGVseSwgdmlh
IFBnQm91bmNlci4pICBJdCBzZWVtcyB0aGF0IHNvbWV0aGluZyBmYWlsZWQg
aW4gdGhlCmNvbm5lY3Rpb24gdG8gUG9zdGdyZXMgYXMgbXkgbWlncmF0aW9u
IHRlcm1pbmF0ZWQgd2l0aCBhbiBlcnJvciBhZnRlciBhYm91dAoxLjUgaG91
cnMgKGZvciBjb21wYXJpc29uIGNyZWF0aW5nIHRoaXMgaW5kZXggc3VjY2Vz
c2Z1bGx5IHRvb2sgYWJvdXQgMy41CmhvdXJzKS4NCg0KXGQgdGFibGVfbmFt
ZSBzaG93ZWQgdGhlIGluZGV4IG1hcmtlZCBhcyBpbnZhbGlkIHNvIEkgcmFu
ICdkcm9wIGluZGV4JywKaW50ZW5kaW5nIHRvIHJ1biB0aGUgaW5kZXggY3Jl
YXRpb24gYWdhaW4uIFRoZSBhdmVyYWdlIHF1ZXJ5IGR1cmF0aW9uCmFnYWlu
c3QgdGhpcyBkYXRhYmFzZSBpbW1lZGlhdGVseSBpbmNyZWFzZWQgZnJvbSB+
MW1zIHRvIH4yNTBtcywgYW5kIHN0YXllZAppbiB0aGUgcmFuZ2UgNTDigJMz
NTBtcyBmb3IgdGhlIG5leHQgdGVuIG1pbnV0ZXMsIHVudGlsIHNvbWVvbmUg
c3BvdHRlZCB0aGF0CnRoZXJlIHdhcyBzdGlsbCBhIHByb2Nlc3Mgb24gdGhl
IHNlcnZlciB0aGF0IHdhcyBydW5uaW5nIOKAmGNyZWF0ZSBpbmRleOKAmS4g
CktpbGxpbmcgdGhhdCBwcm9jZXNzIGNhdXNlZCBwZXJmb3JtYW5jZSB0byBy
ZXR1cm4gdG8gbm9ybWFsLg0KDQpUaGlzIHdhcyByYXRoZXIgYmFkIGZvciB0
aGUgYXZhaWxhYmlsaXR5IG9mIG91ciBhcHBsaWNhdGlvbiBkdXJpbmcgdGhv
c2UgdGVuCm1pbnV0ZXMhDQoNCkkgd291bGQgZXhwZWN0IHRoYXQgcnVubmlu
ZyDigJhkcm9wIGluZGV44oCZIHdoaWxlIHRoYXQgaW5kZXggaXMgc3RpbGwg
YmVpbmcKY3JlYXRlZCB3b3VsZCBlaXRoZXIgZmFpbCBpbW1lZGlhdGVseSwg
b3Igd2FpdCwgd2l0aG91dCBwZXJmb3JtYW5jZSBpbXBhY3QsCnVudGlsIHRo
ZSDigJhjcmVhdGUgaW5kZXggY29uY3VycmVudGx54oCZIGhhZCBjb21wbGV0
ZWQuCgo=

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: pg admin corta resultado
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14230: Wrong timeline returned by pg_stop_backup on a standby