Thread: BUG #14238: crate index hang
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
guang-dih.lei@nasa.gov writes: > I have a table with around 108 millions records. After I issued the > following 'create index' command, it just hang and can never finish: Can you collect a few stack traces after activity seems to end? https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend regards, tom lane