Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDhYq-0001fU-CI for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:27:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qDhYj-00083A-AF for pgsql-bugs@arkaria.postgresql.org; Mon, 26 Jun 2023 08:26:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDgJY-0002Dh-8p for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 07:07:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qDgJV-000XHb-M4 for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 07:07:07 +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=9gNuFT578hbj/EQBKCjy1p88Cmp3h98LxbyatfwVEgg=; b=YZvASHj1H5+/WRLGB0PzvtCgCg Zq7jE4NxKLtBaWJU77xZLSQvQzrdwXZ9U5OecW7/irIWIh21tv9oHNXdfYsGuS3OwGiv/0nM6v7X3 vsV09R32DWMoYXlV/d3lpTgBA7hJTG5gZP2z266Q51XZT3qkeeKJMKpFIU58iBjhNVoBeRj8SCGdV yS/bxkfgQzrXALeRf+egIcKqKu6zUYtwfxKpeuVWVDEveDY+ar6esbPYOVdlqK/RqAgx9WlDDfbiQ h4DOkJ8urvAmjGWy/PMHC0IF1sfYOAsxUZiTK6aWfNmkGapLENDQxCv2fZxYiC1G9LbK9pZE2jW5B oNMy61bQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qDgJU-0003yh-Ke for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 07:07:04 +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 1qDgJS-001WaC-Jx for pgsql-bugs@lists.postgresql.org; Mon, 26 Jun 2023 07:07:02 +0000 Content-Type: multipart/mixed; boundary="===============5292309121701872626==" MIME-Version: 1.0 Subject: BUG #17999: comment to BUG 17990 (PSQL Process hangs in parallel mode) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ess.bee59@gmail.com Reply-To: ess.bee59@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 26 Jun 2023 07:06:07 +0000 Message-ID: <17999-a83f0f7060beabda@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 --===============5292309121701872626== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk5OQpMb2dnZWQgYnk6ICAgICAgICAgIFNlcmdlIEJlbGxpbmEKRW1h aWwgYWRkcmVzczogICAgICBlc3MuYmVlNTlAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuOApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dS0yMjA0LWphbW15LWFtZDY0LWJhc2UKRGVz Y3JpcHRpb246ICAgICAgICAKCkhlbGxvLA0KU29ycnksIEkgcmVwb3J0ZWQgbGFzdCB3ZWVrIG15 IGZpcnN0IGJ1ZyB0byBwb3N0Z3Jlc3FsICh1c2luZyBteSBndXRodWIKYWNjb3VudCksIGJ1dCBJ IGRvIG5vdCBmaW5kIHRoZSB3YXkgdG8gZWRpdCB0aGUgYnVnIGNyZWF0ZWQgKDE3OTkwKQ0KKGNv dWxkIHlvdSBwbGVhc2UgaGVscCBtZSB0byBiZWNvbWUgYWJsZSB0byBlZGl0IHRoZSBidWc/KQ0K DQpTbyBiZWxvdyBteSByZXNwb25zZSB0byB0aG9tYXMgbXVucm86DQoNCkhlbGxvIFRob21hcywg dGhhbmsgZm9yIHlvdXIgcmVzcG9uc2UuDQoxLVRoZSBleHBsYWluIHRvIHRoZSBTUUwNCiAgIFFV RVJZIFBMQU4NCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CiBTb3J0ICAoY29zdD0zMzc3NDE5MDE3NzIuNTAuLjMzNzc0MjEwMzQ2NS40MCByb3dzPTgwNjc3 MTYwIHdpZHRoPTEwMjApDQogICBTb3J0IEtleTogKChzdF9hcmVhKHN0X2ludGVyc2VjdGlvbiht LndheSwgc3RfdW5pb24ocS53YXkpLCAnLTEnOjpkb3VibGUKcHJlY2lzaW9uKSkgLyBzdF9hcmVh KG0ud2F5KSkpIERFU0MNCiAgIC0+ICBHcm91cEFnZ3JlZ2F0ZSAgKGNvc3Q9MzAyNTIyMTc3OTAx Ljg2Li4zMzc2OTUxODMwNjUuNDYgcm93cz04MDY3NzE2MAp3aWR0aD0xMDIwKQ0KICAgICAgICAg R3JvdXAgS2V5OiBtLm9zbV9pZCwgbS5oaWdod2F5LCBtLndheQ0KICAgICAgICAgLT4gIEdhdGhl ciBNZXJnZSAgKGNvc3Q9MzAyNTIyMTc3OTAxLjg2Li4zMTcwNzkxNTkwMTguNjkKcm93cz0xMjQ5 ODg1OTA4ODUgd2lkdGg9MTY3NSkNCiAgICAgICAgICAgICAgIFdvcmtlcnMgUGxhbm5lZDogMg0K ICAgICAgICAgICAgICAgLT4gIFNvcnQgIChjb3N0PTMwMjUyMjE3NjkwMS44NC4uMzAyNjUyMzcz MzUwLjY4CnJvd3M9NTIwNzg1Nzk1MzUgd2lkdGg9MTY3NSkNCiAgICAgICAgICAgICAgICAgICAg IFNvcnQgS2V5OiBtLm9zbV9pZCwgbS5oaWdod2F5LCBtLndheQ0KICAgICAgICAgICAgICAgICAg ICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjQyLi4yMTc0MjI5Mzc0MjcuNTYKcm93cz01MjA3 ODU3OTUzNSB3aWR0aD0xNjc1KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFBhcmFs bGVsIFNlcSBTY2FuIG9uIG9zbV9wb2x5X25vX2J1ZiBxIAooY29zdD0wLjAwLi4yMjM5NTc1NjEu MDMgcm93cz05MzkxNDEgd2lkdGg9NjYzKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgRmlsdGVyOiAoKChsYW5kdXNlID0gQU5ZCigne2ZvcmVzdCxhbGxvdG1lbnRzLGZsb3dlcmJl ZCxvcmNoYXJkLHZpbmV5YXJkLHJlY3JlYXRpb25fZ3JvdW5kLHZpbGxhZ2VfZ3JlZW59Jzo6dGV4 dFtdKSkKT1IgKGxlaXN1cmUgPSBBTlkgKCd7Z2FyZGVuLHBhcmssbmF0dXJlX3Jlc2VydmV9Jzo6 dGV4dFtdKSkpIEFORAooKHN0X2FyZWEoKHN0X3RyYW5zZm9ybSh3YXksIDQzMjYpKTo6Z2VvZ3Jh cGh5LCB0cnVlKSAvICcxMDAwMDAwJzo6ZG91YmxlCnByZWNpc2lvbikgPCAnNTAwMCc6OmRvdWJs ZSBwcmVjaXNpb24pKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4g dXNpbmcgb3NtX2xpbmVfYnVmXzUwX2lkeCBvbgpvc21fbGluZV9idWZfNTAgbSAgKGNvc3Q9MC40 Mi4uMjMxMTkzLjQxIHJvd3M9ODA2OCB3aWR0aD0xMDEyKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKHdheSAmJiBxLndheSkNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIEZpbHRlcjogKChoaWdod2F5IElTIE5PVCBOVUxMKSBBTkQKc3RfaW50 ZXJzZWN0cyh3YXksIHEud2F5KSkNCiBKSVQ6DQogICBGdW5jdGlvbnM6IDEyDQogICBPcHRpb25z OiBJbmxpbmluZyB0cnVlLCBPcHRpbWl6YXRpb24gdHJ1ZSwgRXhwcmVzc2lvbnMgdHJ1ZSwgRGVm b3JtaW5nCnRydWUNCigxNyByb3dzKQ0KDQoyLWNhbmNlbCByZXF1ZXN0Og0KSSBkbyBub3QgZXhh Y3RseSByZW1lbWJlciB3aGF0IHRoZSBwcm9jZXNzIGRpZCBhZnRlciBteSBjYW5jZWwgcmVxdWVz dCAoSQpoYWQgcG9zc2libHkgdG8gcmVzdGFydCB0aGUgREIpDQpCdXQgbXkgcHJvYmxlbSBpcywg dGhlIFNRTCBkaWQgbm90IGVuZCBhZnRlciBob3VycyENClRoZSBDUFUgaW4gdGhlIGxhc3QgdGVz dCB3YXMgMTAwJSAoYXMgc2VlbiBpbiB0aGUgdG9wIHV0aWxpdHkpDQoNClNvcnJ5LCBJIHdhcyBu b3QgcHJlcGFyZWQgdG8gZXhhbWluZSB0aGUgc2l0dWF0aW9uLCBsYXRlciBJIGZvdW5kIHNvbWUK Y29tbWFuZHMgdG8gZ2V0IHRoZSBwZ19zdGF0X2FjdGl2aXR5Lg0KKEkgYW0gbm90IGV4cGVydCBv biBMaW51eCBhbmQgcHJlZmVyIG5vdCB0byBzdGFydCBkZWJ1Z2VyIG9yIHN1Y2ggdXRpbGl0aWVz KQoNCg0KU28sIEkgd2lsbCBzdGFydCBhIHJldGVzdCB0aGlzIHdlZWsuDQpyZWdhcmRzCgo= --===============5292309121701872626==--