BUG #14238: crate index hang

Поиск
Список
Период
Сортировка
От guang-dih.lei@nasa.gov
Тема BUG #14238: crate index hang
Дата
Msg-id 20160708151747.1426.60150@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14238: crate index hang  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIzOApMb2dnZWQgYnk6ICAg
ICAgICAgIEd1YW5nLURpaCBMZWkKRW1haWwgYWRkcmVzczogICAgICBndWFu
Zy1kaWgubGVpQG5hc2EuZ292ClBvc3RncmVTUUwgdmVyc2lvbjogOS41LjMK
T3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCAtIENlbnRPUyByZWxlYXNlIDYu
OApEZXNjcmlwdGlvbjogICAgICAgIAoKSSBoYXZlIGEgdGFibGUgd2l0aCBh
cm91bmQgMTA4IG1pbGxpb25zIHJlY29yZHMuIEFmdGVyIEkgaXNzdWVkIHRo
ZQpmb2xsb3dpbmcgJ2NyZWF0ZSBpbmRleCcgY29tbWFuZCwgaXQganVzdCBo
YW5nIGFuZCBjYW4gbmV2ZXIgZmluaXNoOg0KDQpDUkVBVEUgSU5ERVggaV9n
ZW9fYm94IE9OIGdlb21ldHJpY29iamVjdCBVU0lORyBnaXN0IChnZW9fYm94
KTsNCg0KSGVyZSBpcyBteSBzY2hlbWEgb24gdGhlIHRhYmxlOg0KbWlyYWRv
cj0jIFxkIGdlb21ldHJpY29iamVjdDsNCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgVGFibGUgInB1YmxpYy5nZW9tZXRyaWNvYmplY3QiDQog
ICBDb2x1bW4gICAgfCAgVHlwZSAgIHwgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgTW9kaWZpZXJzICAgICAgICAgICAgCiAgICAgICAgICAgICAg
ICAgIA0KLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0NCiBnZW9tZXRyaWNpZCB8IGludGVnZXIgfCBub3QgbnVs
bCBkZWZhdWx0Cm5leHR2YWwoJ2dlb21ldHJpY29iamVjdF9nZW9tZXRyaWNp
ZF9zZXEnOjpyZWdjbGFzcykNCiBzcGF0aWFsaWQgICB8IGludGVnZXIgfCBu
b3QgbnVsbA0KIGdlb19ib3ggICAgIHwgYm94ICAgICB8IG5vdCBudWxsDQpJ
bmRleGVzOg0KICAgICJnZW9tZXRyaWNvYmplY3RfcGtleSIgUFJJTUFSWSBL
RVksIGJ0cmVlIChnZW9tZXRyaWNpZCkNCiAgICAiaV9nZW9fc3BhdGlhbGlk
IiBidHJlZSAoc3BhdGlhbGlkKQ0KRm9yZWlnbi1rZXkgY29uc3RyYWludHM6
DQogICAgImZrX2dlb29ial9yZWZfc3BhdG9iaiIgRk9SRUlHTiBLRVkgKHNw
YXRpYWxpZCkgUkVGRVJFTkNFUwpzcGF0aWFsb2JqZWN0KHNwYXRpYWxpZCkg
T04gVVBEQVRFIENBU0NBREUgT04gREVMRVRFIENBU0NBREUNCg0KV2UgcHV0
IGEgc3RyYWNlIG9uIHRoZSBjcmVhdGUgaW5kZXggcHJvY2VzcywgdGhlIG91
dHB1dCBqdXN0IHN0b3AgYWZ0ZXIKYXJvdW5kIDMwIG1pbnV0ZXMuIEhlcmUg
aXMgdGhlIGZpbmFsIG91dHB1dCBvZiB0aGUgc3RyYWNlOg0KDQpvcGVuKCJi
YXNlLzk3NDEyNjIzNS8xMzM4MDA3OTI4X2ZzbSIsIE9fUkRXUikgPSAtMSBF
Tk9FTlQgKE5vIHN1Y2ggZmlsZSBvcgpkaXJlY3RvcnkpDQpsc2Vlayg1Mywg
MCwgU0VFS19FTkQpICAgICAgICAgICAgICAgICAgPSA1MjcyMjg5MjgNCndy
aXRlKDUzLAoiXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwIi4uLiwKODE5MikgPSA4MTkyDQpsc2Vlayg1MSwgNzYxNTYxMDg4LCBT
RUVLX1NFVCkgICAgICAgICAgPSA3NjE1NjEwODgNCnJlYWQoNTEsICJcMzI1
bFwzXDBcMzBcMFwwXDBcMjQ2XDIzM1wzMDQKXDI2MDI+XDMwMFwzMTVcMzE0
XDMxNFwzMTRcMzE0XDIzMGVAXDBcMFwwXDBcMFwwXDBcMFxyXDBqb0tcMChc
MD1cblwzMjdcMjQzcFwyNzUyQFwwXDBcMFwwXDBwZkBcMzE1XDMxNFwzMTRc
MzE0XDMxNFwzMTRcMzY0XDI3N1wyNFwyNTZHXDM0MXpcMjU0ZUBcclwwcm9c
MzRcMChcMFwyMTdcMzAyXDM2NShcXFwxNypAXDBcMFwwXDBcMHBmQFwzMjdc
MjQzcD1cblwzMjdcMzVcMzAwKVxcXDIxN1wzMDJcMzY1XDIyMGVAXHJcMHRv
T1wwKFwwXDIxN1wzMDJcMzY1KFxcXDE3KkBcMFwwXDBcMCIuLi4sCjgxOTIp
ID0gODE5Mg0KbHNlZWsoNTEsIDc2NTEwODIyNCwgU0VFS19TRVQpICAgICAg
ICAgID0gNzY1MTA4MjI0DQpyZWFkKDUxLCAiXFxvXDJcMFwzMFwwXDBcMFwy
NDZcMjMzXDMwNApcMjYwMj5cMzAwXDMxNVwzMTRcMzE0XDMxNFwzMTRcMjMw
ZUBcMFwwXDBcMFwwXDBcMFwwXHJcMFwzMDRyXDIwXDAoXDBcMjcwXDM2XDIw
NVwzNTNRODVAXDBcMFwwXDBcMHBmQFwyMzJcMjMxXDIzMVwyMzFcMjMxXDIz
MVwzNzE/e1wyNFwyNTZHXDM0MVwzMTJlQFxyXDBcMzA1clFcMChcMHtcMjRc
MjU2R1wzNDF6LUBcMFwwXDBcMFwwcGZAXDM3XDIwNVwzNTNRXDI3MFwzNlwz
MFwzMDBxPVxuXDMyN1wyNDNAZkBcclwwXDMwNnI2XDAoXDBcMjE3XDMwMlwz
NjUoXFxcMzE3NEBcMFwwXDBcMCIuLi4sCjgxOTIpID0gODE5Mg0KbHNlZWso
NTEsIDIzMzUzNzUzNiwgU0VFS19TRVQpICAgICAgICAgID0gMjMzNTM3NTM2
DQpyZWFkKDUxLCAiJD9cM1wwXDMwXDBcMFwwXDI0NlwyMzNcMzA0ClwyNjAy
PlwzMDBcMzE1XDMxNFwzMTRcMzE0XDMxNFwyMzBlQFwwXDBcMFwwXDBcMFww
XDBcclwwXDMxNHY6XDAoXDBcMTBcMjU0XDM0WmR7KUBcMFwwXDBcMFwwXDIw
MGZAJVw2XDIwMVwyMjVDXDIxM1wzNTQ/UFwyMTVcMjI3blwyMlwzZkBcclww
XDMyMXYyXDAoXDBcMjRcMjU2R1wzNDF6XDMyNDNAXDBcMFwwXDBcMHBmQHE9
XG5cMzI3XDI0M3BcMzE1XDI3N0hcMzQxelwyNFwyNTY3ZkBcclwwXDMyNXYw
XDAoXDBcMzI3XDI0M3A9XG5XNUBcMFwwXDBcMCIuLi4sCjgxOTIpID0gODE5
Mg0Kb3BlbigiYmFzZS85NzQxMjYyMzUvMTMzODAwNzkyOF9mc20iLCBPX1JE
V1IpID0gLTEgRU5PRU5UIChObyBzdWNoIGZpbGUgb3IKZGlyZWN0b3J5KQ0K
bHNlZWsoNTMsIDAsIFNFRUtfRU5EKSAgICAgICAgICAgICAgICAgID0gNTI3
MjM3MTIwDQp3cml0ZSg1MywKIlwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMCIuLi4sCjgxOTIpID0gODE5Mg0Kb3BlbigiYmFzZS85
NzQxMjYyMzUvMTMzODAwNzkyOF9mc20iLCBPX1JEV1IpID0gLTEgRU5PRU5U
IChObyBzdWNoIGZpbGUgb3IKZGlyZWN0b3J5KQ0KbHNlZWsoNTMsIDAsIFNF
RUtfRU5EKSAgICAgICAgICAgICAgICAgID0gNTI3MjQ1MzEyDQp3cml0ZSg1
MywKIlwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFww
XDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBc
MFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMFwwXDBcMCIu
Li4sCjgxOTIpID0gODE5Mg0KbHNlZWsoNTEsIDY2OTI4NjQwMCwgU0VFS19T
RVQpICAgICAgICAgID0gNjY5Mjg2NDAwDQpyZWFkKDUxLCAiSiFcMVwwXDMw
XDBcMFwwXDI0NlwyMzNcMzA0ClwyNjAyPlwzMDBcMzE1XDMxNFwzMTRcMzE0
XDMxNFwyMzBlQFwwXDBcMFwwXDBcMFwwXDBcclwwXDI1NXpcMjNcMChcMFwy
MjZDXDIxM2xcMzQ3XDI3MyNAdVwyMjNcMzBcNFZqZUBcblwzMjdcMjQzcD1K
XCJAXDM0N1wzNzNcMjUxXDM2MVwzMjJhZUBcclwwXDI2MHpcMzVcMChcMDtc
MzM3T1wyMTVcMjI3XDM2QEBcMjc2XDIzN1wzMi9cMzM1QGZAXDIyXDIwM1wz
MDBcMzEyXDI0MVwyMDU/QFxmXDIrXDIwN1wyNlwzNTVlQFxyXDBcMjYweiNc
MChcMFwyMTdcMzAyXDM2NShcXFwzNTc7QFwyNTRcMzRaZCIuLi4sCjgxOTIp
ID0gODE5Mg0KDQpJIGFtIG5vdCBzdXJlIGFib3V0IHRoZSBtaXNzaW5nIF9m
c20gZmlsZSBtZXNzYWdlLiBIb3dldmVyLCB3ZSBzYXcgdGhlCm1lc3NhZ2Ug
cmlnaHQgZnJvbSB0aGUgYmVnaW5uaW5nIG9mIHN0cmFjZSBvdXRwdXQuDQoN
Ckkga25vdyB0aGUgaW5kZXggaXMgcHJvYmFibHkgYmVpbmcgY3JlYXRlZCB3
aXRoIGZpbGVwYXRoIDEzMzgwMDc5MjgqLiBUaG9zZQpmaWxlcyB0aW1lc3Rh
bXAgc3RvcCBiZWluZyB1cGRhdGVkIGFmdGVyIHRoZSBzdHJhY2Ugb3V0cHV0
IHN0b3A6DQoNCiQ6L2RiL3Bnc3FsLzkuNS9kYXRhL2Jhc2UvOTc0MTI2MjM1
JCBscyAtbHRyIDEzMzgwMDc5MjgqDQotcnctLS0tLS0tIDEgcG9zdGdyZXMg
cG9zdGdyZXMgMTA3Mzc0MTgyNCBKdWwgIDcgMTk6MjcgMTMzODAwNzkyOC4x
DQotcnctLS0tLS0tIDEgcG9zdGdyZXMgcG9zdGdyZXMgMTA3Mzc0MTgyNCBK
dWwgIDcgMTk6MjcgMTMzODAwNzkyOC4yDQotcnctLS0tLS0tIDEgcG9zdGdy
ZXMgcG9zdGdyZXMgMTA3Mzc0MTgyNCBKdWwgIDcgMTk6MjcgMTMzODAwNzky
OC4zDQotcnctLS0tLS0tIDEgcG9zdGdyZXMgcG9zdGdyZXMgIDUyNzI1MzUw
NCBKdWwgIDcgMTk6MjggMTMzODAwNzkyOC40DQotcnctLS0tLS0tIDEgcG9z
dGdyZXMgcG9zdGdyZXMgMTA3Mzc0MTgyNCBKdWwgIDcgMTk6MzIgMTMzODAw
NzkyOA0KDQpUaGUgZGF0YWJhc2Ugc2VydmVyIGlzIG9uIGEgaG9zdCB3aXRo
IDMyR0IgUkFNLiBNeSBzaGFyZWRfYnVmZmVycyBpcyBzZXQgYXQKOEdCLiBJ
IGhhdmUgdHJpZWQgYm90aCAncG9zaXgnIGFuZCAnc3lzdicgb24gJ2R5bmFt
aWNfc2hhcmVkX21lbW9yeV90eXBlJwpwYXJhbWV0ZXIuIE5laXRoZXIgb25l
IGNhbiBoYXZlIHRoZSBpbmRleCBjcmVhdGlvbiBwcm9jZXNzIGNvbXBsZXRl
ZC4gDQoNCldlIGhhdmUgdGhlIHNhbWUgZGF0YWJhc2Ugb24gYW5vdGhlciBo
b3N0IHdpdGggUG9zdGdyZXMtOS4xIHdoaWNoIHdlIGRvbid0CmhhdmUgcHJv
YmxlbSBjcmVhdGluZyB0aGF0IGluZGV4LiBTaW5jZSA5LjEgd2lsbCBiZSBv
dXQgb2Ygc3VwcG9ydCBzb29uLCB3ZQphcmUgbWlncmF0aW5nIGl0IHRvIGEg
bmV3IDkuNSBzZXJ2ZXIuIA0KDQpJIGFwcHJlY2lhdGUgaWYgYW55b25lIGNh
biBoZWxwLiBUaGFua3MuDQoNCgoK

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14237: Terrible performance after accidentally running 'drop index' for index still being created
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14238: crate index hang