Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sh7dq-00DDjO-N9 for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Aug 2024 13:14:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sh7dn-002e7o-4s for pgsql-bugs@arkaria.postgresql.org; Thu, 22 Aug 2024 13:14:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sh7PF-002Wau-4j for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 12:59:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sh7P8-000u1n-1s for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 12:59:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=mKwYaFWJ/32GODO6/jMWLIWntQ0o9JMSCFW8SN+XZD8=; b=edzV3i/oIhwa92uUC3zFgjjxEb 4aXcqIGUVQvv6okLkWFgL6qckS43ibbfpE5TqJzWz00ByAIb5Qv5dItWJvvJ5eIzLq8SEflhVv4HZ J64QQICLlMUWReqcBNPeXNb/p8kD6QksU1NO9WBrP6sv1YDY+TZA+QhFlK5wBGw2OUDvUN1sF4emu JPi/xgnsVsxWgcFP30jKNmXPltFAt0j/pAF3Ps1Mozre3wcPDXyHTJyREsNVupBLsp0HxG+lP5taI uyw/tUzw2fHiyyEzEy8FNHBoiqNRIFbDNdU9FE11JJ54wjf/cxEeMJiWssK2cG1SIQsDeW+qznKYk Oqjj92mw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sh7P7-0037Bp-0c for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 12:59:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sh7P5-0073Om-1r for pgsql-bugs@lists.postgresql.org; Thu, 22 Aug 2024 12:59:03 +0000 Content-Type: multipart/mixed; boundary="===============0962898982407238903==" MIME-Version: 1.0 Subject: BUG #18588: Cannot force/let database use parallel execution in simple case. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 22 Aug 2024 12:58:23 +0000 Message-ID: <18588-204730f9394441a8@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0962898982407238903== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU4OApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTUuNgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjogICAgICAgIAoKSGks DQoNCkkgZm91bmQgdmVyeSBzdHJhbmdlIGNhc2Ugd2hlbiBkYXRhYmFzZSBzaW1wbGUgZG8gbm90 IHVzZSBwYXJhbGxlbCBwbGFuIGluCnRyaXZpYWwgcXVlcnkgKHdoZXJlIGl0IHNob3VsZCBwcm92 aWRlIGh1Z2UgYmVuZWZpdCkNCkluIHRoZSBzYW1lIHRpbWUgLSBpZiBJIGFkZCBvbmUgbm90IGV4 aXN0cyAoc3Vic2VsZWN0KSB0aGUgZGF0YWJhc2UgZXhlY3V0ZQpxdWVyeSBpbiBwYXJhbGxlbCBt b2RlIChwcm92aWRpbmcgOHggc3BlZWR1cCkuDQoNCkluaXRpYWwgcXVlcnk6DQpleHBsYWluIGFu YWx5emUgc2VsZWN0IHRvcGljX2lkIGFzIHkwXyBmcm9tCnB1YmxpYy5uZWdvdGlhdGlvbl90b3Bp Y19hcmNoaXZlX3AwMDUgdGhpc18gd2hlcmUKdGhpc18uZW1wbG95ZXJfaWQ9JzgxNjE0NCc7DQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBJbmRleCBTY2FuIHVzaW5nIG5lZ290aWF0aW9uX3RvcGlj X2FyY2hpdmVfcDAwNV9lbXBsb3llcl9pZF9yZXN1bWVfaWRfaWR4Cm9uIG5lZ290aWF0aW9uX3Rv cGljX2FyY2hpdmVfcDAwNSB0aGlzXyAgKGNvc3Q9MC4xMS4uMjUwMTk3Mi4xMyByb3dzPTUwNTc1 Nwp3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMjAuLjY5OS4zMjIgcm93cz01MTAwNDAgbG9vcHM9 MSkNCiAgIEluZGV4IENvbmQ6IChlbXBsb3llcl9pZCA9IDgxNjE0NCkNCiBQbGFubmluZyBUaW1l OiAwLjEzMiBtcw0KIEV4ZWN1dGlvbiBUaW1lOiA3MTcuMDA1IG1zDQoNCnNldHRpbmcgDQpzZXQg bWluX3BhcmFsbGVsX2luZGV4X3NjYW5fc2l6ZSB0byAnOGtCJzsgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQpzZXQgbWluX3BhcmFsbGVsX3RhYmxlX3NjYW5fc2l6ZSB0byAnOGtCJzsNCnNldCBwYXJhbGxl bF90dXBsZV9jb3N0IHRvIDA7DQpzZXQgcGFyYWxsZWxfc2V0dXBfY29zdCB0byAwOw0KDQpoYXZl IG5vIGVmZmVjdC4NCg0KRXZlbiB3aXRoIHRoZSBzZXQgZm9yY2VfcGFyYWxsZWxfbW9kZSB0byBv biAtIG5vIGVmZmVjdDoNCm5lZ290aWF0aW9uX2NoYXRfYXJjaGl2ZT0jIGV4cGxhaW4gYW5hbHl6 ZSBzZWxlY3QgdG9waWNfaWQgYXMgeTBfIGZyb20KcHVibGljLm5lZ290aWF0aW9uX3RvcGljX2Fy Y2hpdmVfcDAwNSB0aGlzXyB3aGVyZQp0aGlzXy5lbXBsb3llcl9pZD0nODE2MTQ0JzsNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEdhdGhlciAgKGNvc3Q9MC4xMS4uMjUwMTk3 Mi4xMyByb3dzPTUwNTc1NyB3aWR0aD04KSAoYWN0dWFsCnRpbWU9NS4yMzQuLjc0OC42MDYgcm93 cz01MTAwNDAgbG9vcHM9MSkNCiAgIFdvcmtlcnMgUGxhbm5lZDogMQ0KICAgV29ya2VycyBMYXVu Y2hlZDogMQ0KICAgU2luZ2xlIENvcHk6IHRydWUNCiAgIC0+ICBJbmRleCBTY2FuIHVzaW5nCm5l Z290aWF0aW9uX3RvcGljX2FyY2hpdmVfcDAwNV9lbXBsb3llcl9pZF9yZXN1bWVfaWRfaWR4IG9u Cm5lZ290aWF0aW9uX3RvcGljX2FyY2hpdmVfcDAwNSB0aGlzXyAgKGNvc3Q9MC4xMS4uMjUwMTk3 Mi4xMyByb3dzPTUwNTc1Nwp3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wMjEuLjY2Mi43OTggcm93 cz01MTAwNDAgbG9vcHM9MSkNCiAgICAgICAgIEluZGV4IENvbmQ6IChlbXBsb3llcl9pZCA9IDgx NjE0NCkNCiBQbGFubmluZyBUaW1lOiAwLjExNyBtcw0KIEV4ZWN1dGlvbiBUaW1lOiA3NjguMTE3 IG1zDQoNCg0KSW4gdGhlIHNhbWUgdGltZSBhIGJpdCBtb3JlIGNvbXBsaWNhdGVkIHF1ZXJ5IG92 ZXIgdGhlIHNhbWUgZGF0YSAtIGhhcHBpbHkKd29yayBpbiBwYXJhbGxlbCAoYWRkZWQgQU5EIE5P VCBFWElTVFMgKFNFTEVDVCBGUk9NIGFwcGxpY2FudF9ibGFja19saXN0CldIRVJFIHRoaXNfLmVt cGxveWVyX2lkPWFwcGxpY2FudF9ibGFja19saXN0LmVtcGxveWVyX2lkIEFORAp0aGlzXy5hcHBs aWNhbnRfaWQ9YXBwbGljYW50X2JsYWNrX2xpc3QuYXBwbGljYW50X2lkKSBjb25kaXRpb24pOg0K DQpleHBsYWluIGFuYWx5emUgc2VsZWN0IHRvcGljX2lkIGFzIHkwXyBmcm9tCnB1YmxpYy5uZWdv dGlhdGlvbl90b3BpY19hcmNoaXZlX3AwMDUgdGhpc18gd2hlcmUgdGhpc18uZW1wbG95ZXJfaWQ9 JzgxNjE0NCcKQU5EIE5PVCBFWElTVFMgKFNFTEVDVCBGUk9NIGFwcGxpY2FudF9ibGFja19saXN0 IFdIRVJFCnRoaXNfLmVtcGxveWVyX2lkPWFwcGxpY2FudF9ibGFja19saXN0LmVtcGxveWVyX2lk IEFORAp0aGlzXy5hcHBsaWNhbnRfaWQ9YXBwbGljYW50X2JsYWNrX2xpc3QuYXBwbGljYW50X2lk KTsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBR VUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tDQogR2F0aGVyICAoY29zdD0xMC4yNy4uMjQ5ODQ0NS42MCByb3dzPTUwNTc1NCB3aWR0 aD04KSAoYWN0dWFsCnRpbWU9MS40NTIuLjEwNi4zMzUgcm93cz01MDk5MDEgbG9vcHM9MSkNCiAg IFdvcmtlcnMgUGxhbm5lZDogNw0KICAgV29ya2VycyBMYXVuY2hlZDogNw0KICAgLT4gIFBhcmFs bGVsIEhhc2ggQW50aSBKb2luICAoY29zdD0xMC4yNy4uMjQ5ODQ0NS42MCByb3dzPTcyMjUxIHdp ZHRoPTgpCihhY3R1YWwgdGltZT0wLjIyNC4uOTQuNzU0IHJvd3M9NjM3MzggbG9vcHM9OCkNCiAg ICAgICAgIEhhc2ggQ29uZDogKCh0aGlzXy5lbXBsb3llcl9pZCA9IGFwcGxpY2FudF9ibGFja19s aXN0LmVtcGxveWVyX2lkKQpBTkQgKHRoaXNfLmFwcGxpY2FudF9pZCA9IGFwcGxpY2FudF9ibGFj a19saXN0LmFwcGxpY2FudF9pZCkpDQogICAgICAgICAtPiAgUGFyYWxsZWwgSW5kZXggU2NhbiB1 c2luZwpuZWdvdGlhdGlvbl90b3BpY19hcmNoaXZlX3AwMDVfZW1wbG95ZXJfaWRfcmVzdW1lX2lk X2lkeCBvbgpuZWdvdGlhdGlvbl90b3BpY19hcmNoaXZlX3AwMDUgdGhpc18gIChjb3N0PTAuMTEu LjI0OTc2MzcuMDcgcm93cz03MjI1MQp3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDE5Li44NS4z MDUgcm93cz02Mzc1NSBsb29wcz04KQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGVtcGxv eWVyX2lkID0gODE2MTQ0KQ0KICAgICAgICAgLT4gIFBhcmFsbGVsIEhhc2ggIChjb3N0PTEwLjEz Li4xMC4xMyByb3dzPTIgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTAuMDI3Li4wLjAyNyByb3dzPTUg bG9vcHM9OCkNCiAgICAgICAgICAgICAgIEJ1Y2tldHM6IDEwMjQgIEJhdGNoZXM6IDEgIE1lbW9y eSBVc2FnZTogNDBrQg0KICAgICAgICAgICAgICAgLT4gIFBhcmFsbGVsIEluZGV4IE9ubHkgU2Nh biB1c2luZyBlbXBsb3llcl90b191c2VyX2luZGV4IG9uCmFwcGxpY2FudF9ibGFja19saXN0ICAo Y29zdD0wLjA4Li4xMC4xMyByb3dzPTIgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTAuMDEzLi4wLjAy MiByb3dzPTQxIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoZW1w bG95ZXJfaWQgPSA4MTYxNDQpDQogICAgICAgICAgICAgICAgICAgICBIZWFwIEZldGNoZXM6IDUN CiBQbGFubmluZyBUaW1lOiAyLjU1MCBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAxMjEuODEwIG1zDQoo MTQgcm93cykNCg0KSSBmZWVsIHNvbWV0aGluZyB3cm9uZyB0aGVyZSBhbmQgSSBoYXBweSB0byBh c3Npc3QgZGVidWdnaW5nIHRoaXMgaXNzdWUgKEkKY2FuIHVzZSBnZGIgd2l0aCBzZXBhcmF0ZWQg aW5zdGFuY2Ugb2YgdGhlIHNhbWUgZGF0YSkuDQpNYXkgYmUgSSBtaXNzaW5nIHNvbWUgb2J2aW91 cyByZXN0cmljdGlvbnMgYnV0IGNhbm5vdCBmaW5kIGFueXRoaW5nIHN1Y2ggaW4KZG9jdW1lbnRh dGlvbiBhbmQgc3BlZWR1cCBwcm92aWRlZCBieSBwYXJhbGxlbCBxdWVyeSB3b3VsZCBiZSBlbm9y bW91cyBpbiBteQpjYXNlLg0KDQpLaW5kIFJlZ2FyZHMsDQpNYXhpbQoK --===============0962898982407238903==--