BUG #14163: Index only scan Buffer read enlarged when the data is random
| От | digoal@126.com |
|---|---|
| Тема | BUG #14163: Index only scan Buffer read enlarged when the data is random |
| Дата | |
| Msg-id | 20160528160941.19432.17678@wrigleys.postgresql.org обсуждение исходный текст |
| Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE2MwpMb2dnZWQgYnk6ICAg ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjZiZXRhMQpPcGVyYXRp bmcgc3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpwb3N0Z3Jlcz0jIGNyZWF0ZSB0YWJsZSB0Ymw3KGlkIGludCBwcmlt YXJ5IGtleSwgaW5mbyB0ZXh0KTsNCkNSRUFURSBUQUJMRQ0KcG9zdGdyZXM9 IyBpbnNlcnQgaW50byB0Ymw3IHNlbGVjdCB0cnVuYyhyYW5kb20oKSoxMDAw MDAwMCksCm1kNShyYW5kb20oKTo6dGV4dCkgZnJvbSBnZW5lcmF0ZV9zZXJp ZXMoMSw1MDAwMDAwKSBvbiBjb25mbGljdCBvbgpjb25zdHJhaW50IHRibDdf cGtleSBkbyBub3RoaW5nOw0KSU5TRVJUIDAgMzkzNDU0OA0KcG9zdGdyZXM9 IyB2YWN1dW0gYW5hbHl6ZSB0Ymw3Ow0KVkFDVVVNDQoNCnBvc3RncmVzPSMg c2V0IGVuYWJsZV9zZXFzY2FuPW9mZjsNClNFVA0KcG9zdGdyZXM9IyBleHBs YWluIChhbmFseXplLGJ1ZmZlcnMsY29zdHMsdGltaW5nLHZlcmJvc2UpIHNl bGVjdCBpZCBmcm9tCnRibDc7DQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVS WSBQTEFOCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogSW5kZXgg T25seSBTY2FuIHVzaW5nIHRibDdfcGtleSBvbiBwdWJsaWMudGJsNyAgKGNv c3Q9MC40My4uNzMxNzYuNjMKcm93cz0zOTM0NTQ3IHdpZHRoPTQpIChhY3R1 YWwgdGltZT0wLjA0Ny4uOTY5Ljg0MSByb3dzPTM5MzQ1NDggbG9vcHM9MSkN CiAgIE91dHB1dDogaWQNCiAgIEhlYXAgRmV0Y2hlczogMA0KICAgQnVmZmVy czogc2hhcmVkIGhpdD00MTc5MA0KIFBsYW5uaW5nIHRpbWU6IDAuMDU1IG1z DQogRXhlY3V0aW9uIHRpbWU6IDE2ODYuOTcxIG1zDQooNiByb3dzKQ0KDQpw b3N0Z3Jlcz0jIHNlbGVjdCByZWxwYWdlcyBmcm9tIHBnX2NsYXNzIHdoZXJl IHJlbG5hbWU9J3RibDdfcGtleSc7DQogcmVscGFnZXMgDQotLS0tLS0tLS0t DQogICAgMTQxNTgNCigxIHJvdykNCg0Kd2hlbiBpIGNsdXN0ZXIgaXQgb3Ig bG9hZCBpdCB0byBhbm90aGVyIHRhYmxlIG9yZGVyZWQuIA0KdGhlIHNlcSBz Y2FuIG9ubHkgc2NhbiAxMDc1NSBwYWdlcy4gIA0KaXQncyBhIGJ1ZyBvciB3 ZSBjYW4gb3B0aW1pemVkIGl0PyAgIA0KDQpwb3N0Z3Jlcz0jIGNyZWF0ZSB0 YWJsZSB0Ymw4KGlkIGludCBwcmltYXJ5IGtleSwgaW5mbyB0ZXh0KTsNCkNS RUFURSBUQUJMRQ0KcG9zdGdyZXM9IyBpbnNlcnQgaW50byB0Ymw4IHNlbGVj dCAqIGZyb20gdGJsNyBvcmRlciBieSBpZDsNCklOU0VSVCAwIDM5MzQ1NDgN CnBvc3RncmVzPSMgdmFjdXVtIGFuYWx5emUgdGJsODsNClZBQ1VVTQ0KcG9z dGdyZXM9IyBzZWxlY3QgcmVscGFnZXMgZnJvbSBwZ19jbGFzcyB3aGVyZSBy ZWxuYW1lPSd0Ymw4X3BrZXknOw0KIHJlbHBhZ2VzIA0KLS0tLS0tLS0tLQ0K ICAgIDEwNzkxDQooMSByb3cpDQoNCnBvc3RncmVzPSMgZXhwbGFpbiAoYW5h bHl6ZSxidWZmZXJzLGNvc3RzLHRpbWluZyx2ZXJib3NlKSBzZWxlY3QgaWQg ZnJvbQp0Ymw4Ow0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTgog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEluZGV4IE9ubHkgU2Nh biB1c2luZyB0Ymw4X3BrZXkgb24gcHVibGljLnRibDggIChjb3N0PTAuNDMu LjY5ODA5LjYzCnJvd3M9MzkzNDU0NyB3aWR0aD00KSAoYWN0dWFsIHRpbWU9 MC4wMjYuLjkyMS4xMzcgcm93cz0zOTM0NTQ4IGxvb3BzPTEpDQogICBPdXRw dXQ6IGlkDQogICBIZWFwIEZldGNoZXM6IDANCiAgIEJ1ZmZlcnM6IHNoYXJl ZCBoaXQ9MTA3NTUNCiBQbGFubmluZyB0aW1lOiAwLjExMSBtcw0KIEV4ZWN1 dGlvbiB0aW1lOiAxNjI2LjkwOCBtcw0KKDYgcm93cykNCg0KYmVzdCByZWdh cmRzICwgDQpkaWdvYWwNCgoK
В списке pgsql-bugs по дате отправления: