BUG #14302: SQL with LIMIT degrades performance seriously
| От | chenkaijiang@gmail.com |
|---|---|
| Тема | BUG #14302: SQL with LIMIT degrades performance seriously |
| Дата | |
| Msg-id | 20160830064858.15676.40929@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #14302: SQL with LIMIT degrades performance seriously
(Jeff Janes <jeff.janes@gmail.com>)
|
| Список | pgsql-bugs |
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMwMgpMb2dnZWQgYnk6ICAg ICAgICAgIEthaWppYW5nIENoZW4KRW1haWwgYWRkcmVzczogICAgICBjaGVu a2FpamlhbmdAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS41LjMK T3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgNy4yCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpJIGhhdmUgYSB0YWJsZSwgcmVucmVuLnVzZXJfcmVsYXRpb25z IHdpdGggMTAgcGFydGl0aW9ucyBhbmQgY29udGFpbnMgYWJvdXQKMTBNIHJl Y29yZHMuDQoNCkkgY3JlYXRlZCAyIGluZGV4ZXMgb24gaXQgKGluY2x1ZGlu ZyBwYXJlbnQgdGFibGUgYW5kIGFsbCBwYXJ0aXRpb25zKTogDQoxKSB1c2Vy X3JlbGF0aW9uc19wa2V5IC0tIGJ0cmVlIGluZGV4IG9uIHVzZXJfaWQgY29s dW1uDQoyKSB1c2VyX3JlbGF0aW9uc18wX3BhcmVudF9pZF9pZHggLS0gYnRy ZWUgaW5kZXggb24gcGFyZW50X2lkDQoNCkkgcmFuIHRoZSBTUUwgInNlbGVj dCAqIGZyb20gcmVucmVuLnVzZXJfcmVsYXRpb25zIHdoZXJlIHBhcmVudF9p ZD04NDYzNDYKb3JkZXIgYnkgdXNlcl9pZCBsaW1pdCAxMDsiIGFuZCBpdCB0 b29rIDEuNCBzZWMsIHdoaWNoIGlzIHNsb3cuDQpCdXQgInNlbGVjdCAqIGZy b20gcmVucmVuLnVzZXJfcmVsYXRpb25zIHdoZXJlIHBhcmVudF9pZD04NDYz NDYgb3JkZXIgYnkKdXNlcl9pZCIgKG5vIExJTUlUKSBhbmQgaXQgdG9vayAx MDArIG1zLg0KDQp0aGUgZXhwbGFpbiByZXN1bHQ6DQoNCmV4cGxhaW4gc2Vs ZWN0ICogZnJvbSByZW5yZW4udXNlcl9yZWxhdGlvbnMgd2hlcmUgcGFyZW50 X2lkPTg0NjM0NiBvcmRlciBieQp1c2VyX2lkIGxpbWl0IDEwOw0KDQogICBR VUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBMaW1pdCAgKGNvc3Q9NC41Ny4uNDQyLjM1IHJvd3M9MTAgd2lkdGg9MTAy KQ0KICAgLT4gIE1lcmdlIEFwcGVuZCAgKGNvc3Q9NC41Ny4uNDk2NTM0Ljky IHJvd3M9MTEzNDIgd2lkdGg9MTAyKQ0KICAgICAgICAgU29ydCBLZXk6IHVz ZXJfcmVsYXRpb25zLnVzZXJfaWQNCiAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIHVzZXJfcmVsYXRpb25zX3BrZXkgb24gdXNlcl9yZWxhdGlvbnMg Cihjb3N0PTAuMTIuLjUuMjQgcm93cz0xIHdpZHRoPTI3KQ0KICAgICAgICAg ICAgICAgRmlsdGVyOiAocGFyZW50X2lkID0gODQ2MzQ2KQ0KICAgICAgICAg LT4gIEluZGV4IFNjYW4gdXNpbmcgdXNlcl9yZWxhdGlvbnNfMF9wa2V5IG9u IHVzZXJfcmVsYXRpb25zXzAgCihjb3N0PTAuNDIuLjQ5NDI2LjI0IHJvd3M9 ODYyIHdpZHRoPTEwMikNCiAgICAgICAgICAgICAgIEZpbHRlcjogKHBhcmVu dF9pZCA9IDg0NjM0NikNCiAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5n IHVzZXJfcmVsYXRpb25zXzFfcGtleSBvbiB1c2VyX3JlbGF0aW9uc18xIAoo Y29zdD0wLjQyLi40OTQzNy4yMSByb3dzPTEwMjIgd2lkdGg9MTAyKQ0KICAg ICAgICAgICAgICAgRmlsdGVyOiAocGFyZW50X2lkID0gODQ2MzQ2KQ0KICAg ICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgdXNlcl9yZWxhdGlvbnNfMl9w a2V5IG9uIHVzZXJfcmVsYXRpb25zXzIgCihjb3N0PTAuNDIuLjQ5NjgxLjIz IHJvd3M9OTczIHdpZHRoPTEwMykNCiAgICAgICAgICAgICAgIEZpbHRlcjog KHBhcmVudF9pZCA9IDg0NjM0NikNCiAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIHVzZXJfcmVsYXRpb25zXzNfcGtleSBvbiB1c2VyX3JlbGF0aW9u c18zIAooY29zdD0wLjQyLi40OTQyNy4zOCByb3dzPTk5MCB3aWR0aD0xMDIp DQogICAgICAgICAgICAgICBGaWx0ZXI6IChwYXJlbnRfaWQgPSA4NDYzNDYp DQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX3JlbGF0aW9u c180X3BrZXkgb24gdXNlcl9yZWxhdGlvbnNfNCAKKGNvc3Q9MC40Mi4uNDk3 MTMuOTUgcm93cz05NDEgd2lkdGg9MTAyKQ0KICAgICAgICAgICAgICAgRmls dGVyOiAocGFyZW50X2lkID0gODQ2MzQ2KQ0KICAgICAgICAgLT4gIEluZGV4 IFNjYW4gdXNpbmcgdXNlcl9yZWxhdGlvbnNfNV9wa2V5IG9uIHVzZXJfcmVs YXRpb25zXzUgCihjb3N0PTAuNDIuLjQ5NzExLjY1IHJvd3M9MTY4NyB3aWR0 aD0xMDIpDQogICAgICAgICAgICAgICBGaWx0ZXI6IChwYXJlbnRfaWQgPSA4 NDYzNDYpDQogICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX3Jl bGF0aW9uc182X3BrZXkgb24gdXNlcl9yZWxhdGlvbnNfNiAKKGNvc3Q9MC40 Mi4uNDk2NzYuNjAgcm93cz0xMTA0IHdpZHRoPTEwMikNCiAgICAgICAgICAg ICAgIEZpbHRlcjogKHBhcmVudF9pZCA9IDg0NjM0NikNCiAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIHVzZXJfcmVsYXRpb25zXzdfcGtleSBvbiB1 c2VyX3JlbGF0aW9uc183IAooY29zdD0wLjQyLi40OTcxNS4yNyByb3dzPTEx Njggd2lkdGg9MTAyKQ0KICAgICAgICAgICAgICAgRmlsdGVyOiAocGFyZW50 X2lkID0gODQ2MzQ2KQ0KICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcg dXNlcl9yZWxhdGlvbnNfOF9wa2V5IG9uIHVzZXJfcmVsYXRpb25zXzggCihj b3N0PTAuNDIuLjQ5Njk4LjU1IHJvd3M9MTE2OCB3aWR0aD0xMDIpDQogICAg ICAgICAgICAgICBGaWx0ZXI6IChwYXJlbnRfaWQgPSA4NDYzNDYpDQogICAg ICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX3JlbGF0aW9uc185X3Br ZXkgb24gdXNlcl9yZWxhdGlvbnNfOSAKKGNvc3Q9MC40Mi4uNDk2MjAuNjkg cm93cz0xNDI2IHdpZHRoPTEwMykNCiAgICAgICAgICAgICAgIEZpbHRlcjog KHBhcmVudF9pZCA9IDg0NjM0NikNCigyNSByb3dzKQ0KDQpUaW1lOiAxLjM0 NCBtcw0KDQpJdCB1c2VzIHRoZSBJbmRleCBTY2FuIHVzaW5nIGluZGV4IG9u IHVzZXJfaWQsIHdoaWNoIGlzIHZlcnkgc3R1cGlkLg0KDQpJZiBJIGV4cGxh aW4gc2VsZWN0ICogZnJvbSByZW5yZW4udXNlcl9yZWxhdGlvbnMgd2hlcmUg cGFyZW50X2lkPTg0NjM0NgpvcmRlciBieSB1c2VyX2lkLCB0aGVuIGl0IHVz ZXMgdGhlIGluZGV4IG9uIHBhcmVudF9pZCB0byBnZXQgcmVjb3JkcyBhbmQK dGhlbiBzb3J0IGl0LCB3aGljaCBpcyB2ZXJ5IHdpc2Ugc2luY2UgdGhlIG51 bWJlciBvZiBxdWFsaWZpZWQgcmVjb3JkcyBpcwoxNzI1Lg0KDQpGaW5hbGx5 LCBJIGdvdCBhIHdheSB0byB3b3JrIGFyb3VuZDoNCg0KZXhwbGFpbiB3aXRo IHRtcCBhcyAoc2VsZWN0ICogZnJvbSByZW5yZW4udXNlcl9yZWxhdGlvbnMg d2hlcmUKcGFyZW50X2lkPTg0NjM0NiBvcmRlciBieSB1c2VyX2lkKSBzZWxl Y3QgdXNlcl9pZCBmcm9tIHRtcCBsaW1pdCAxMDsNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IFFVRVJZIFBMQU4gICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIExpbWl0ICAoY29zdD0yMzA2 NS4yNC4uMjMwNjUuNDQgcm93cz0xMCB3aWR0aD04KQ0KICAgQ1RFIHRtcA0K ICAgICAtPiAgU29ydCAgKGNvc3Q9MjMwMzYuODkuLjIzMDY1LjI0IHJvd3M9 MTEzNDIgd2lkdGg9MTAyKQ0KICAgICAgICAgICBTb3J0IEtleTogdXNlcl9y ZWxhdGlvbnMudXNlcl9pZA0KICAgICAgICAgICAtPiAgQXBwZW5kICAoY29z dD0wLjAwLi4yMjI3My4wNCByb3dzPTExMzQyIHdpZHRoPTEwMikNCiAgICAg ICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHVzZXJfcmVsYXRpb25zICAo Y29zdD0wLjAwLi4wLjAwIHJvd3M9MQp3aWR0aD0yNykNCiAgICAgICAgICAg ICAgICAgICAgICAgRmlsdGVyOiAocGFyZW50X2lkID0gODQ2MzQ2KQ0KICAg ICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX3JlbGF0 aW9uc18wX3BhcmVudF9pZF9pZHggb24KdXNlcl9yZWxhdGlvbnNfMCAgKGNv c3Q9MC40Mi4uMTY4Mi40OSByb3dzPTg2MiB3aWR0aD0xMDIpDQogICAgICAg ICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChwYXJlbnRfaWQgPSA4NDYz NDYpDQogICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHVz ZXJfcmVsYXRpb25zXzFfcGFyZW50X2lkX2lkeCBvbgp1c2VyX3JlbGF0aW9u c18xICAoY29zdD0wLjQyLi4yMTU2LjAyIHJvd3M9MTAyMiB3aWR0aD0xMDIp DQogICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChwYXJlbnRf aWQgPSA4NDYzNDYpDQogICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIHVzZXJfcmVsYXRpb25zXzJfcGFyZW50X2lkX2lkeCBvbgp1c2Vy X3JlbGF0aW9uc18yICAoY29zdD0wLjQyLi4xODg3LjcxIHJvd3M9OTczIHdp ZHRoPTEwMykNCiAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDog KHBhcmVudF9pZCA9IDg0NjM0NikNCiAgICAgICAgICAgICAgICAgLT4gIElu ZGV4IFNjYW4gdXNpbmcgdXNlcl9yZWxhdGlvbnNfM19wYXJlbnRfaWRfaWR4 IG9uCnVzZXJfcmVsYXRpb25zXzMgIChjb3N0PTAuNDIuLjIwMzUuOTUgcm93 cz05OTAgd2lkdGg9MTAyKQ0KICAgICAgICAgICAgICAgICAgICAgICBJbmRl eCBDb25kOiAocGFyZW50X2lkID0gODQ2MzQ2KQ0KICAgICAgICAgICAgICAg ICAtPiAgSW5kZXggU2NhbiB1c2luZyB1c2VyX3JlbGF0aW9uc180X3BhcmVu dF9pZF9pZHggb24KdXNlcl9yZWxhdGlvbnNfNCAgKGNvc3Q9MC40Mi4uMTgw NS4yOSByb3dzPTk0MSB3aWR0aD0xMDIpDQogICAgICAgICAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6IChwYXJlbnRfaWQgPSA4NDYzNDYpDQogICAgICAg ICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHVzZXJfcmVsYXRpb25z XzVfcGFyZW50X2lkX2lkeCBvbgp1c2VyX3JlbGF0aW9uc181ICAoY29zdD0w LjQyLi4zMjQwLjI5IHJvd3M9MTY4NyB3aWR0aD0xMDIpDQogICAgICAgICAg ICAgICAgICAgICAgIEluZGV4IENvbmQ6IChwYXJlbnRfaWQgPSA4NDYzNDYp DQogICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHVzZXJf cmVsYXRpb25zXzZfcGFyZW50X2lkX2lkeCBvbgp1c2VyX3JlbGF0aW9uc182 ICAoY29zdD0wLjQyLi4yMTQ5LjEwIHJvd3M9MTEwNCB3aWR0aD0xMDIpDQog ICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChwYXJlbnRfaWQg PSA4NDYzNDYpDQogICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVz aW5nIHVzZXJfcmVsYXRpb25zXzdfcGFyZW50X2lkX2lkeCBvbgp1c2VyX3Jl bGF0aW9uc183ICAoY29zdD0wLjQyLi4yMjU2LjUzIHJvd3M9MTE2OCB3aWR0 aD0xMDIpDQogICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChw YXJlbnRfaWQgPSA4NDYzNDYpDQogICAgICAgICAgICAgICAgIC0+ICBJbmRl eCBTY2FuIHVzaW5nIHVzZXJfcmVsYXRpb25zXzhfcGFyZW50X2lkX2lkeCBv bgp1c2VyX3JlbGF0aW9uc184ICAoY29zdD0wLjQyLi4yMzA0LjUxIHJvd3M9 MTE2OCB3aWR0aD0xMDIpDQogICAgICAgICAgICAgICAgICAgICAgIEluZGV4 IENvbmQ6IChwYXJlbnRfaWQgPSA4NDYzNDYpDQogICAgICAgICAgICAgICAg IC0+ICBJbmRleCBTY2FuIHVzaW5nIHVzZXJfcmVsYXRpb25zXzlfcGFyZW50 X2lkX2lkeCBvbgp1c2VyX3JlbGF0aW9uc185ICAoY29zdD0wLjQyLi4yNzU1 LjE2IHJvd3M9MTQyNiB3aWR0aD0xMDMpDQogICAgICAgICAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6IChwYXJlbnRfaWQgPSA4NDYzNDYpDQogICAtPiAg Q1RFIFNjYW4gb24gdG1wICAoY29zdD0wLjAwLi4yMjYuODQgcm93cz0xMTM0 MiB3aWR0aD04KQ0KKDI4IHJvd3MpDQoNClRpbWU6IDEuNDA5IG1zDQoNCmFu ZCAid2l0aCB0bXAgYXMgKHNlbGVjdCAqIGZyb20gcmVucmVuLnVzZXJfcmVs YXRpb25zIHdoZXJlIHBhcmVudF9pZD04NDYzNDYKb3JkZXIgYnkgdXNlcl9p ZCkgc2VsZWN0IHVzZXJfaWQgZnJvbSB0bXAgbGltaXQgMTA7IiB0b29rIG9u bHkgMTAwKyBtcy4NCg0KU28sIEkgdGhpbmsgdGhlIG9wdGltaXplci9wbGFu bmVyIGhhcyBhIHBlcmZvcm1hbmNlIGJ1ZyB3aXRoIExJTUlUIGNsYXVzZS4N Cg0KCgo=
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Rikard PavelicДата:
Сообщение: Re: BUG #14301: function in case expression called when it should not be
Следующее
От: Devrim GündüzДата:
Сообщение: Re: BUG #14299: initdb and man pages are not installed in the alternatives system