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

Поиск
Список
Период
Сортировка
От David Waller
Тема Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created
Дата
Msg-id 6A9A127D-FE6F-422D-BE82-B8154757367F@microsoft.com
обсуждение исходный текст
Ответ на Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created
Список pgsql-bugs
Дерево обсуждения 
T24gMDgvMDcvMjAxNiwgMTY6MDgsICJUb20gTGFuZSIgPHRnbEBzc3MucGdoLnBhLnVzPiB3cm90
ZToNCj4gZHdhbGxlckBtaWNyb3NvZnQuY29tIHdyaXRlczoNCj4gPiBTdW1tYXJ5OiBXaGlsZSBy
dW5uaW5nIOKAmGNyZWF0ZSBpbmRleCBjb25jdXJyZW50bHnigJkgb24gYSB2ZXJ5IGxhcmdlIHRh
YmxlLA0KPiA+IHJ1bm5pbmcg4oCYZHJvcCBpbmRleOKAmSBmb3IgdGhlIHNhbWUgaW5kZXggY2F1
c2VkIFBvc3RncmVzIHRvIHBlcmZvcm0gdGVycmlibHkNCj4gPiBiYWRseSwgdW50aWwgdGhlIOKA
mGNyZWF0ZSBpbmRleOKAmSBzZXJ2ZXIgcHJvY2VzcyB3YXMga2lsbGVkLiAgSSB3b3VsZCBleHBl
Y3QNCj4gPiB0aGF0IHRoZSDigJhkcm9wIGluZGV44oCZIHdvdWxkIGVpdGhlciBmYWlsIGltbWVk
aWF0ZWx5LCBvciB3YWl0LCB3aXRob3V0DQo+ID4gcGVyZm9ybWFuY2UgaW1wYWN0LCB1bnRpbCB0
aGUg4oCYY3JlYXRlIGluZGV4IGNvbmN1cnJlbnRseeKAmSBoYWQgY29tcGxldGVkLg0KPiANCj4g
SG1tLCB0aGUgRFJPUCBJTkRFWCBzaG91bGQgaGF2ZSBibG9ja2VkIHdhaXRpbmcgZm9yIGFuIGV4
Y2x1c2l2ZSBsb2NrIG9uDQo+IHRoZSB0YWJsZSwgYW5kIHRoZW4gb3RoZXIgcXVlcmllcyBvbiB0
aGUgdGFibGUgc2hvdWxkIGhhdmUgcXVldWVkIHVwDQo+IGJlaGluZCB0aGF0IGxvY2sgcmVxdWVz
dC4gIEkgdGhpbmsgdGhlIGZhY3QgdGhhdCB0aGV5IGRpZG4ndCBqdXN0IHN0b3ANCj4gZGVhZCBw
cm9iYWJseSBpbmRpY2F0ZXMgdGhhdCB3aGVuIHRoZSBkZWFkbG9jayBjaGVja2VyIHJhbiwgaXQg
Y29uY2x1ZGVkDQo+IGl0IG5lZWRlZCB0byBsZXQgdGhlbSBqdW1wIHRoZSBxdWV1ZSBhbmQgZ28g
aW4gZnJvbnQgb2YgdGhlIERST1AgSU5ERVggdG8NCj4gYXZvaWQgYSBkZWFkbG9jayAtLS0gbGlr
ZWx5IGJlY2F1c2UgdGhlIGxvY2sgbWFuYWdlciBjb3VsZCBzZWUgdGhhdCB0aGUNCj4gRFJPUCB3
YXMgYmxvY2tlZCBieSB0aGUgQ1JFQVRFIElOREVYIENPTkNVUlJFTlRMWSB3aGlsZSB0aGUgbGF0
dGVyIHdhcw0KPiB3YWl0aW5nIGZvciB0aGUgb3RoZXIgcXVlcmllcyB0byBmaW5pc2guICBTbyB5
b3VyIHNsb3dkb3duIGNvcnJlc3BvbmRzIHRvDQo+IGFuIGV4dHJhIHdhaXQgb2YgZGVhZGxvY2tf
dGltZW91dCBtcyBwZXIgcXVlcnkuICBUaGlzIGlzIG5vdCBhIGJ1ZywgYnV0DQo+IGRlc2lnbmVk
IGJlaGF2aW9yLg0KPg0KPiA+IEkgd291bGQgZXhwZWN0IHRoYXQgcnVubmluZyDigJhkcm9wIGlu
ZGV44oCZIHdoaWxlIHRoYXQgaW5kZXggaXMgc3RpbGwgYmVpbmcNCj4gPiBjcmVhdGVkIHdvdWxk
IGVpdGhlciBmYWlsIGltbWVkaWF0ZWx5LCBvciB3YWl0LCB3aXRob3V0IHBlcmZvcm1hbmNlIGlt
cGFjdCwNCj4gPiB1bnRpbCB0aGUg4oCYY3JlYXRlIGluZGV4IGNvbmN1cnJlbnRseeKAmSBoYWQg
Y29tcGxldGVkLg0KPiANCj4gSWYgdGhlIERST1AncyBsb2NrIHJlcXVlc3QgaXMgbm90IGFsbG93
ZWQgdG8gYmxvY2sgb3RoZXIgaW5jb21pbmcgcmVxdWVzdHMNCj4gZm9yIGEgdGFibGUgbG9jaywg
dGhlIERST1AgY291bGQgZmFjZSBpbmRlZmluaXRlIGxvY2sgc3RhcnZhdGlvbi4gIFRoYXQgaXMN
Cj4gbm90IGJldHRlci4gIFJlZHVjaW5nIGRlYWRsb2NrX3RpbWVvdXQgdG8gemVybyBpcyBub3Qg
Z29pbmcgdG8gaW1wcm92ZQ0KPiB5b3VyIG92ZXJhbGwgcGVyZm9ybWFuY2UsIGVpdGhlci4NCg0K
VGhhbmsgeW91IGZvciB0aGUgZGV0YWlsZWQgZXhwbGFuYXRpb24uICBUaGlzIGFsbCBzZWVtcyB2
ZXJ5IHNlbnNpYmxlLCBhbmQNCnJlYXNvbmFibGUgYmVoYXZpb3VyIGZyb20gUG9zdGdyZXMuICBZ
ZXQuLi4gaXQgc3RpbGwgJ2FsbG93ZWQnIG1lIHRvIHNob290IG15c2VsZg0KcGFpbmZ1bGx5IGlu
IHRoZSBmb290LiAgVXNlciBlcnJvciwgSSBhZ3JlZSwgeWV0IHBlb3BsZSBtYWtlIG1pc3Rha2Vz
IC0gY291bGQNClBvc3RncmVzIGJlaGF2ZSBtb3JlIGdyYWNlZnVsbHk/ICANCg0KRm9yIGV4YW1w
bGUsIHdvdWxkIGl0IGJlIGF0IGFsbCBmZWFzaWJsZSBmb3IgUG9zdGdyZXMgdG8gaGFuZGxlIERE
TCBzdGF0ZW1lbnRzDQpkaWZmZXJlbnRseSBmcm9tIHJlZ3VsYXIgcmVxdWVzdHM/ICBJbiB0aGlz
IGV4YW1wbGUgaXQgd2FzIHBvaW50bGVzcyBmb3IgRFJPUA0KSU5ERVggdG8gdGFrZSBhbnkgbG9j
a3Mgd2hpbGUgdGhlcmUgd2FzIGFscmVhZHkgYW5vdGhlciBEREwgc3RhdGVtZW50IChDUkVBVEUN
CklOREVYKSBydW5uaW5nLiAgQ291bGQgaXQgaGF2ZSBiZWVuIGFkZGVkIHRvIGEgcXVldWUgb2Yg
RERMIHN0YXRlbWVudHMgYWdhaW5zdA0KdGhhdCB0YWJsZSBhbmQgbm90IGF0dGVtcHRlZCB0byB0
YWtlIGEgbG9jayB1bnRpbCBDUkVBVEUgSU5ERVggY29tcGxldGVkIGFuZA0KRFJPUCBJTkRFWCB0
aGVuIHJlYWNoZWQgdGhlIGhlYWQgb2YgdGhlIHF1ZXVlPyAgDQoNClRoYW5rcywNCg0KRGF2aWQN
Cg0K

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

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Incorrect Spanish error message.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created