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?  (Jeff Janes <jeff.janes@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Invalid indexes should not consume update overhead
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Invalid indexes should not consume update overhead