Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iGU4d-0005Ho-GG for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Oct 2019 20:21:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iGU4b-0002K3-AM for pgsql-bugs@arkaria.postgresql.org; Fri, 04 Oct 2019 20:21:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iGU4b-0002Jn-1m for pgsql-bugs@lists.postgresql.org; Fri, 04 Oct 2019 20:21:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iGU4W-0002yS-N9 for pgsql-bugs@lists.postgresql.org; Fri, 04 Oct 2019 20:21:08 +0000 Content-Type: multipart/mixed; boundary="===============6884424036119048435==" MIME-Version: 1.0 Subject: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jeremy@musicsmith.net Reply-To: jeremy@musicsmith.net, pgsql-bugs@lists.postgresql.org Date: Fri, 04 Oct 2019 20:20:32 +0000 Message-ID: <16040-eaacad11fecfb198@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6884424036119048435== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjA0MApMb2dnZWQgYnk6ICAgICAgICAgIEplcmVteSBTbWl0aApFbWFp bCBhZGRyZXNzOiAgICAgIGplcmVteUBtdXNpY3NtaXRoLm5ldApQb3N0Z3JlU1FMIHZlcnNpb246 IDEyLjAKT3BlcmF0aW5nIHN5c3RlbTogICBPZmZpY2lhbCBEb2NrZXIgSW1hZ2UsIENlbnRPUzcK RGVzY3JpcHRpb246ICAgICAgICAKCkkgaGF2ZSBhbHNvIHRyaWVkIHRoaXMgd2l0aCAxMS4zLCAx MS40LCBhbmQgMTEuNSwgc28gdGhpcyBpcyBub3QgbmV3IGluCjEyLjAuICBIZXJlJ3MgYSByZWFs bHkgYmFzaWMgd2F5IHRvIHJlcHJvZHVjZSB0aGlzOg0KDQpwb3N0Z3Jlcz0jIEJFR0lOOw0KQkVH SU4NCnBvc3RncmVzPSMNCnBvc3RncmVzPSMgLS0gQ3JlYXRlIGEgdGVzdCB0YWJsZSBhbmQgc29t ZSBkYXRhDQpwb3N0Z3Jlcz0jIENSRUFURSBUQUJMRSB0ZXN0IChhIGludCk7DQpDUkVBVEUgVEFC TEUNCnBvc3RncmVzPSMgSU5TRVJUIElOVE8gdGVzdCBTRUxFQ1QgZ2VuZXJhdGVfc2VyaWVzKDEs MTApOw0KSU5TRVJUIDAgMTANCnBvc3RncmVzPSMgYWx0ZXIgdGFibGUgdGVzdCBzZXQgKHBhcmFs bGVsX3dvcmtlcnMgPSA0KTsNCkFMVEVSIFRBQkxFDQpwb3N0Z3Jlcz0jIC0tIFVzZSBhdXRvX2V4 cGxhaW4gdG8gc2hvdyBwbGFuIG9mIHF1ZXJ5IGluIHRoZSBmdW5jdGlvbg0KcG9zdGdyZXM9IyBM T0FEICdhdXRvX2V4cGxhaW4nOyANCkxPQUQNCnBvc3RncmVzPSMgU0VUIGF1dG9fZXhwbGFpbi5s b2dfYW5hbHl6ZSA9IG9uOw0KU0VUDQpwb3N0Z3Jlcz0jIFNFVCBjbGllbnRfbWluX21lc3NhZ2Vz ID0gbG9nOw0KU0VUDQpwb3N0Z3Jlcz0jIFNFVCBhdXRvX2V4cGxhaW4ubG9nX25lc3RlZF9zdGF0 ZW1lbnRzID0gb247DQpTRVQNCnBvc3RncmVzPSMgU0VUIGF1dG9fZXhwbGFpbi5sb2dfbWluX2R1 cmF0aW9uID0gMDsNClNFVA0KcG9zdGdyZXM9IyAtLSBTZXQgcGFyYWxsZWwgY29zdHMgYXJ0aWZp Y2lhbGx5IGxvdywgZm9yIGRlbW9uc3RyYXRpb24KcHVycG9zZXMNCnBvc3RncmVzPSMgc2V0IHBh cmFsbGVsX3R1cGxlX2Nvc3QgPSAwOw0KU0VUDQpwb3N0Z3Jlcz0jIHNldCBwYXJhbGxlbF9zZXR1 cF9jb3N0ID0gMDsNClNFVA0KcG9zdGdyZXM9IyBzZXQgbWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVy X2dhdGhlciA9IDQ7DQpTRVQNCnBvc3RncmVzPSMgLS0gTm9ybWFsIHF1ZXJ5IHdpbGwgdXNlIDQg d29ya2Vycw0KcG9zdGdyZXM9IyBTRUxFQ1QgdGVzdC5hLCBjb3VudCgqKSBGUk9NIHRlc3QgR1JP VVAgQlkgdGVzdC5hOw0KTE9HOiAgZHVyYXRpb246IDE5LjI4MCBtcyAgcGxhbjoNClF1ZXJ5IFRl eHQ6IFNFTEVDVCB0ZXN0LmEsIGNvdW50KCopIEZST00gdGVzdCBHUk9VUCBCWSB0ZXN0LmE7DQpG aW5hbGl6ZSBIYXNoQWdncmVnYXRlICAoY29zdD0yNS41Ni4uMjcuNTYgcm93cz0yMDAgd2lkdGg9 MTIpIChhY3R1YWwKdGltZT0xNi42NDkuLjE2Ljc5NSByb3dzPTEwIGxvb3BzPTEpDQogIEdyb3Vw IEtleTogYQ0KICAtPiAgR2F0aGVyICAoY29zdD0xOS41Ni4uMjEuNTYgcm93cz04MDAgd2lkdGg9 MTIpIChhY3R1YWwKdGltZT0yLjg1My4uMTguNzQ0IHJvd3M9MTAgbG9vcHM9MSkNCiAgICAgICAg V29ya2VycyBQbGFubmVkOiA0DQogICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6IDQNCiAgICAgICAg LT4gIFBhcnRpYWwgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MTkuNTYuLjIxLjU2IHJvd3M9MjAwIHdp ZHRoPTEyKQooYWN0dWFsIHRpbWU9MC40OTMuLjAuNTE5IHJvd3M9MiBsb29wcz01KQ0KICAgICAg ICAgICAgICBHcm91cCBLZXk6IGENCiAgICAgICAgICAgICAgLT4gIFBhcmFsbGVsIFNlcSBTY2Fu IG9uIHRlc3QgIChjb3N0PTAuMDAuLjE2LjM4IHJvd3M9NjM4CndpZHRoPTQpIChhY3R1YWwgdGlt ZT0wLjAwOS4uMC4wODMgcm93cz0yIGxvb3BzPTUpDQogYSAgfCBjb3VudA0KLS0tLSstLS0tLS0t DQogIDkgfCAgICAgMQ0KICAzIHwgICAgIDENCiAgNSB8ICAgICAxDQogIDQgfCAgICAgMQ0KIDEw IHwgICAgIDENCiAgNiB8ICAgICAxDQogIDIgfCAgICAgMQ0KICA3IHwgICAgIDENCiAgMSB8ICAg ICAxDQogIDggfCAgICAgMQ0KKDEwIHJvd3MpDQoNCnBvc3RncmVzPSMNCnBvc3RncmVzPSMgQ1JF QVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gdGVzdF9jb3VudCgpDQpwb3N0Z3Jlcy0jICAgUkVUVVJO UyBUQUJMRSAoYSBpbnQsIG4gYmlnaW50KSBBUw0KcG9zdGdyZXMtIyAgICQkDQpwb3N0Z3JlcyQj ICAgICBCRUdJTg0KcG9zdGdyZXMkIyAgICAgICBSRVRVUk4gUVVFUlkgU0VMRUNUIHRlc3QuYSwg Y291bnQoKikgRlJPTSB0ZXN0IEdST1VQIEJZCnRlc3QuYTsNCnBvc3RncmVzJCMgICAgIEVORDsN CnBvc3RncmVzJCMgICAkJA0KcG9zdGdyZXMtIyBMQU5HVUFHRSBQTFBHU1FMOw0KQ1JFQVRFIEZV TkNUSU9ODQpwb3N0Z3Jlcz0jDQpwb3N0Z3Jlcz0jIC0tIFRoaXMgcXVlcnkgd2lsbCBub3QgdXNl IHBhcmFsbGVsIHdvcmtlcnMNCnBvc3RncmVzPSMgU0VMRUNUICogRlJPTSB0ZXN0X2NvdW50KCk7 DQpMT0c6ICBkdXJhdGlvbjogMC40MzcgbXMgIHBsYW46DQpRdWVyeSBUZXh0OiBTRUxFQ1QgdGVz dC5hLCBjb3VudCgqKSBGUk9NIHRlc3QgR1JPVVAgQlkgdGVzdC5hDQpIYXNoQWdncmVnYXRlICAo Y29zdD00OC4yNS4uNTAuMjUgcm93cz0yMDAgd2lkdGg9MTIpIChhY3R1YWwKdGltZT0wLjE5My4u MC4yNzYgcm93cz0xMCBsb29wcz0xKQ0KICBHcm91cCBLZXk6IGENCiAgLT4gIFNlcSBTY2FuIG9u IHRlc3QgIChjb3N0PTAuMDAuLjM1LjUwIHJvd3M9MjU1MCB3aWR0aD00KSAoYWN0dWFsCnRpbWU9 MC4wMTAuLjAuMDk2IHJvd3M9MTAgbG9vcHM9MSkNCkxPRzogIGR1cmF0aW9uOiAxLjA2OSBtcyAg cGxhbjoNClF1ZXJ5IFRleHQ6IFNFTEVDVCAqIEZST00gdGVzdF9jb3VudCgpOw0KRnVuY3Rpb24g U2NhbiBvbiB0ZXN0X2NvdW50ICAoY29zdD0wLjI1Li4xMC4yNSByb3dzPTEwMDAgd2lkdGg9MTIp IChhY3R1YWwKdGltZT0wLjg5NS4uMC45Njggcm93cz0xMCBsb29wcz0xKQ0KIGEgIHwgbg0KLS0t LSstLS0NCiAgOSB8IDENCiAgMyB8IDENCiAgNSB8IDENCiAgNCB8IDENCiAxMCB8IDENCiAgNiB8 IDENCiAgMiB8IDENCiAgNyB8IDENCiAgMSB8IDENCiAgOCB8IDENCigxMCByb3dzKQ0KDQpwb3N0 Z3Jlcz0jIC0tIEEgd29ya2Fyb3VuZCBmb3IgbG9uZy1ydW5uaW5nIHF1ZXJpZXMsIHVzaW5nIENS RUFURSBUQUJMRSwKd2hpY2ggd2lsbCBydW4gaW4gcGFyYWxsZWwNCnBvc3RncmVzPSMgQ1JFQVRF IE9SIFJFUExBQ0UgRlVOQ1RJT04gdGVzdF9jb3VudDIoKQ0KcG9zdGdyZXMtIyAgIFJFVFVSTlMg VEFCTEUgKGEgaW50LCBuIGJpZ2ludCkgQVMNCnBvc3RncmVzLSMgICAkJA0KcG9zdGdyZXMkIyAg ICAgQkVHSU4NCnBvc3RncmVzJCMgICAgICAgQ1JFQVRFIFRFTVBPUkFSWSBUQUJMRSB0ZXN0X2Nv dW50Ml90ZW1wX3RhYmxlIEFTDQpwb3N0Z3JlcyQjICAgICAgICAgU0VMRUNUIHRlc3QuYSwgY291 bnQoKikgRlJPTSB0ZXN0IEdST1VQIEJZIHRlc3QuYTsNCnBvc3RncmVzJCMgICAgICAgUkVUVVJO IFFVRVJZIHNlbGVjdCAqIGZyb20gdGVzdF9jb3VudDJfdGVtcF90YWJsZTsNCnBvc3RncmVzJCMg ICAgIEVORDsNCnBvc3RncmVzJCMgICQkDQpwb3N0Z3Jlcy0jIExBTkdVQUdFIFBMUEdTUUw7DQpD UkVBVEUgRlVOQ1RJT04NCnBvc3RncmVzPSMNCnBvc3RncmVzPSMgLS0gVGhlIENSRUFURSBUQUJM RSBBUyBxdWVyeSB3aWxsIHVzZSBwYXJhbGxlbCB3b3JrZXJzLCBidXQgdGhlDQpwb3N0Z3Jlcz0j IC0tIFJFVFVSTiBRVUVSWSBzdGF0ZW1lbnQgd2lsbCBub3QNCnBvc3RncmVzPSMgU0VMRUNUICog RlJPTSB0ZXN0X2NvdW50MigpOw0KTE9HOiAgZHVyYXRpb246IDI0LjEzOSBtcyAgcGxhbjoNClF1 ZXJ5IFRleHQ6IENSRUFURSBURU1QT1JBUlkgVEFCTEUgdGVzdF9jb3VudDJfdGVtcF90YWJsZSBB Uw0KICAgICAgICBTRUxFQ1QgdGVzdC5hLCBjb3VudCgqKSBGUk9NIHRlc3QgR1JPVVAgQlkgdGVz dC5hDQpGaW5hbGl6ZSBIYXNoQWdncmVnYXRlICAoY29zdD0yNS41Ni4uMjcuNTYgcm93cz0yMDAg d2lkdGg9MTIpIChhY3R1YWwKdGltZT0yMS44MTkuLjIxLjg5NiByb3dzPTEwIGxvb3BzPTEpDQog IEdyb3VwIEtleTogYQ0KICAtPiAgR2F0aGVyICAoY29zdD0xOS41Ni4uMjEuNTYgcm93cz04MDAg d2lkdGg9MTIpIChhY3R1YWwKdGltZT0wLjc1NS4uMjIuOTY2IHJvd3M9MTAgbG9vcHM9MSkNCiAg ICAgICAgV29ya2VycyBQbGFubmVkOiA0DQogICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6IDQNCiAg ICAgICAgLT4gIFBhcnRpYWwgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MTkuNTYuLjIxLjU2IHJvd3M9 MjAwIHdpZHRoPTEyKQooYWN0dWFsIHRpbWU9MC4xMDUuLjAuMTQ4IHJvd3M9MiBsb29wcz01KQ0K ICAgICAgICAgICAgICBHcm91cCBLZXk6IGENCiAgICAgICAgICAgICAgLT4gIFBhcmFsbGVsIFNl cSBTY2FuIG9uIHRlc3QgIChjb3N0PTAuMDAuLjE2LjM4IHJvd3M9NjM4CndpZHRoPTQpIChhY3R1 YWwgdGltZT0wLjAwOS4uMC4wNTYgcm93cz0yIGxvb3BzPTUpDQpMT0c6ICBkdXJhdGlvbjogMC40 MjAgbXMgIHBsYW46DQpRdWVyeSBUZXh0OiBzZWxlY3QgKiBmcm9tIHRlc3RfY291bnQyX3RlbXBf dGFibGUNClNlcSBTY2FuIG9uIHRlc3RfY291bnQyX3RlbXBfdGFibGUgIChjb3N0PTAuMDAuLjMw LjQwIHJvd3M9MjA0MCB3aWR0aD0xMikKKGFjdHVhbCB0aW1lPTAuMDE0Li4wLjMwNSByb3dzPTEw IGxvb3BzPTEpDQpMT0c6ICBkdXJhdGlvbjogMjYuMTE4IG1zICBwbGFuOg0KUXVlcnkgVGV4dDog U0VMRUNUICogRlJPTSB0ZXN0X2NvdW50MigpOw0KRnVuY3Rpb24gU2NhbiBvbiB0ZXN0X2NvdW50 MiAgKGNvc3Q9MC4yNS4uMTAuMjUgcm93cz0xMDAwIHdpZHRoPTEyKSAoYWN0dWFsCnRpbWU9MjUu ODQ1Li4yNS45OTQgcm93cz0xMCBsb29wcz0xKQ0KIGEgIHwgbg0KLS0tLSstLS0NCiAgOSB8IDEN CiAgMyB8IDENCiAgNSB8IDENCiAgNCB8IDENCiAxMCB8IDENCiAgNiB8IDENCiAgMiB8IDENCiAg NyB8IDENCiAgMSB8IDENCiAgOCB8IDENCigxMCByb3dzKQ0KDQoNCg0KSXQncyBub3Qgb2J2aW91 cyBmcm9tIHRoZSBkb2N1bWVudGF0aW9uCihodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2Nz LzEyL3doZW4tY2FuLXBhcmFsbGVsLXF1ZXJ5LWJlLXVzZWQuaHRtbCkKdGhhdCB0aGlzIHNob3Vs ZCBiZSB0aGUgY2FzZS4gIFJFVFVSTiBRVUVSWSBpcyBub3QgaW50ZXJydXB0aWJsZSwgbGlrZSBh CmN1cnNvciBvciBmb3IgbG9vcC4KCg== --===============6884424036119048435==--