BUG #14253: b-tree no index range scan?
От | digoal@126.com |
---|---|
Тема | BUG #14253: b-tree no index range scan? |
Дата | |
Msg-id | 20160717030316.1425.90322@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #14253: b-tree no index range scan?
|
Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDI1MwpMb2dnZWQgYnk6ICAg ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjUuMwpPcGVyYXRpbmcg c3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAgICAg CgpISSwNCiAgd2hlbiBpIHVzZSBiLXRyZWUgc2NhbiBtYW55IHR1cGxlcyhz cHJlYWQgaW5kZXggbGVhZiBwYWdlKSwgdGhlcmUgaGFzIGJpZwppbmRleCBw YWdlIHNjYW5zLCBsYXJnZXIgdGhhbiB0aGUgaW5kZXgncyByZWFsIHNpemUu ICB3aHk/DQppcyB0aGUgZXhwbGFpbidzIGJ1Zz8gb3IgUG9zdGdyZVNRTCBu byBpbmRleCByYW5nZSBzY2FuPyAgDQoNCg0KcG9zdGdyZXM9IyBjcmVhdGUg dW5sb2dnZWQgdGFibGUgdGJsKGlkIGludCBwcmltYXJ5IGtleSwgaW5mbyB0 ZXh0LCBjcnRfdGltZQp0aW1lc3RhbXApOw0KcG9zdGdyZXM9IyBpbnNlcnQg aW50byB0Ymwgc2VsZWN0IHRydW5jKHJhbmRvbSgpKjEwMDAwMDAwMCksJ3Rl c3QnLG5vdygpCmZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsNTAwMDAwMDApIG9u IGNvbmZsaWN0IG9uIGNvbnN0cmFpbnQgdGJsX3BrZXkgZG8Kbm90aGluZzsN CnBvc3RncmVzPSMgdmFjdXVtIGFuYWx5emUgdGJsOw0K57Si5byV5ZKMaGVh cOeahHBhZ2Vz5Y2g55SoDQoNCnBvc3RncmVzPSMgc2VsZWN0IHJlbHBhZ2Vz IGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZT0ndGJsJzsNCiByZWxwYWdl cyANCi0tLS0tLS0tLS0NCiAgIDI1MDYwMA0KKDEgcm93KQ0KDQpwb3N0Z3Jl cz0jIHNlbGVjdCByZWxwYWdlcyBmcm9tIHBnX2NsYXNzIHdoZXJlIHJlbG5h bWU9J3RibF9wa2V5JzsNCiByZWxwYWdlcyANCi0tLS0tLS0tLS0NCiAgIDEw Nzg4MQ0KKDEgcm93KQ0KDQoNCmkgc2VlIHBvc3RncmVzcWwgaGFzIGJpLWxp bmsgYmV0d2VlbiBpbmRleCBwYWdlcywgd2h5IG5vdCB1c2UgaXQgcmVkdWNl IHNjYW4KaW5kZXggcGFnZXM/ICANCnNyYy9pbmNsdWRlL2FjY2Vzcy9uYnRy ZWUuaA0KDQp0eXBlZGVmIHN0cnVjdCBCVFBhZ2VPcGFxdWVEYXRhDQp7DQog ICAgICAgIEJsb2NrTnVtYmVyIGJ0cG9fcHJldjsgICAgICAgICAgLyogbGVm dCBzaWJsaW5nLCBvciBQX05PTkUgaWYKbGVmdG1vc3QgKi8NCiAgICAgICAg QmxvY2tOdW1iZXIgYnRwb19uZXh0OyAgICAgICAgICAvKiByaWdodCBzaWJs aW5nLCBvciBQX05PTkUgaWYKcmlnaHRtb3N0ICovDQogICAgICAgIHVuaW9u DQogICAgICAgIHsNCiAgICAgICAgICAgICAgICB1aW50MzIgICAgICAgICAg bGV2ZWw7ICAgICAgICAgIC8qIHRyZWUgbGV2ZWwgLS0tIHplcm8gZm9yCmxl YWYgcGFnZXMgKi8NCiAgICAgICAgICAgICAgICBUcmFuc2FjdGlvbklkIHhh Y3Q7ICAgICAgICAgICAgIC8qIG5leHQgdHJhbnNhY3Rpb24gSUQsIGlmCmRl bGV0ZWQgKi8NCiAgICAgICAgfSAgICAgICAgICAgICAgICAgICAgICAgYnRw bzsNCiAgICAgICAgdWludDE2ICAgICAgICAgIGJ0cG9fZmxhZ3M7ICAgICAg ICAgICAgIC8qIGZsYWcgYml0cywgc2VlIGJlbG93ICovDQogICAgICAgIEJU Q3ljbGVJZCAgICAgICBidHBvX2N5Y2xlaWQ7ICAgLyogdmFjdXVtIGN5Y2xl IElEIG9mIGxhdGVzdCBzcGxpdAoqLw0KfSBCVFBhZ2VPcGFxdWVEYXRhOw0K DQoNCnBvc3RncmVzPSMgZXhwbGFpbiAoYW5hbHl6ZSx2ZXJib3NlLHRpbWlu Zyxjb3N0cyxidWZmZXJzKSBzZWxlY3QgaWQgZnJvbSB0YmwKb2Zmc2V0IDEw MDAwMDAgbGltaXQgMTA7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVS WQpQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0NCiBMaW1pdCAgKGNvc3Q9MjU5NjguNDkuLjI1OTY4Ljc1IHJvd3M9MTAg d2lkdGg9NCkgKGFjdHVhbAp0aW1lPTUyOC45MTQuLjUyOC45MjEgcm93cz0x MCBsb29wcz0xKQ0KICAgT3V0cHV0OiBpZA0KICAgQnVmZmVyczogc2hhcmVk IGhpdD03NTA1NTQNCiAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgdGJs X3BrZXkgb24gcHVibGljLnRibCAgKGNvc3Q9MC41Ni4uMTAyMTY4Ny4zMgpy b3dzPTM5MzQ0MTg0IHdpZHRoPTQpIChhY3R1YWwgdGltZT0wLjAzMC4uMzQ3 LjQwOSByb3dzPTEwMDAwMTAgbG9vcHM9MSkNCiAgICAgICAgIE91dHB1dDog aWQNCiAgICAgICAgIEhlYXAgRmV0Y2hlczogMA0KICAgICAgICAgQnVmZmVy czogc2hhcmVkIGhpdD03NTA1NTQgICANCiBQbGFubmluZyB0aW1lOiAwLjA4 MyBtcw0KIEV4ZWN1dGlvbiB0aW1lOiA1MjguOTQ4IG1zDQooOSByb3dzKQ0K DQoNCnBvc3RncmVzPSMgZXhwbGFpbiAoYW5hbHl6ZSx2ZXJib3NlLHRpbWlu Zyxjb3N0cyxidWZmZXJzKSBzZWxlY3QgaWQgZnJvbSB0YmwKbGltaXQgMTAw MDAxMDsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZClBMQU4gICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIExpbWl0 ICAoY29zdD0wLjU2Li4yNTk2OC43NSByb3dzPTEwMDAwMTAgd2lkdGg9NCkg KGFjdHVhbAp0aW1lPTAuMDMyLi43MzYuOTI5IHJvd3M9MTAwMDAxMCBsb29w cz0xKQ0KICAgT3V0cHV0OiBpZA0KICAgQnVmZmVyczogc2hhcmVkIGhpdD03 NTA1NTQNCiAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgdGJsX3BrZXkg b24gcHVibGljLnRibCAgKGNvc3Q9MC41Ni4uMTAyMTY4Ny4zMgpyb3dzPTM5 MzQ0MTg0IHdpZHRoPTQpIChhY3R1YWwgdGltZT0wLjAzMS4uMzYyLjc5MSBy b3dzPTEwMDAwMTAgbG9vcHM9MSkNCiAgICAgICAgIE91dHB1dDogaWQNCiAg ICAgICAgIEhlYXAgRmV0Y2hlczogMA0KICAgICAgICAgQnVmZmVyczogc2hh cmVkIGhpdD03NTA1NTQgIA0KIFBsYW5uaW5nIHRpbWU6IDAuMDk3IG1zDQog RXhlY3V0aW9uIHRpbWU6IDkxNi4yNTYgbXMNCig5IHJvd3MpDQoNCnRoYW5r cywNCmJlc3QgcmVnYXJkcywNCmRpZ29hbA0KCgo=
В списке pgsql-bugs по дате отправления:
Следующее
От: Peter GeogheganДата:
Сообщение: Re: Invalid indexes should not consume update overhead