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 1oNtCC-0002LB-DT for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Aug 2022 09:49:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oNtCB-0008Vw-AI for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Aug 2022 09:49:11 +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 <13207961@qq.com>) id 1oNnDt-0005kn-RU for pgsql-bugs@lists.postgresql.org; Tue, 16 Aug 2022 03:26:36 +0000 Received: from out203-205-251-53.mail.qq.com ([203.205.251.53]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <13207961@qq.com>) id 1oNnDl-000460-2Z for pgsql-bugs@lists.postgresql.org; Tue, 16 Aug 2022 03:26:33 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1660620372; bh=K38lZr6yqluqOSUxuQV8VtfezyWUZ5t7z9xwOCjkVX8=; h=From:To:Cc:Subject:Date; b=PjbvJiROUfUyGfxEFI8YDUF1vskjK3euB/eHOjS0RcPwdiCfAXZoqLpPmy1/5iw5H XK9vwRavqy9TCbEcYKpRFUBEuj+drSzVAZipD5iG6VRv3UotYBSPqLR5vMwRwKlPU1 be94KX6R1UZrPj84+gaxAszkU7XKHQNltRXVQxts= X-QQ-XMAILINFO: M6mqk12bCjNiO5+F1fP/WuSmS70Kd259ea758HT1n0uAmroddNsDUUrD0/Gkbj VHh++PkVvRKbF0eiOaaN9BrLbbsJCXxtxNGZUAxfY/NKxdA6Op5Og6ftPSG2XlNFw/0vyyhwlHxou vqJWbYwlRhSQAZ7nd6YyZC15siHnRUmQY43+Qi0hQUG0UYOFYE1k1+sjNPAKhYIplOjMdg1MyoNl3 ycrj/Q5dKP3m93a2eHHwMks9sHBrFwi6toPpot7EA00Gc8pyX1CiqdaSiLPOmK6ynWkm5uf0QdEYO Ak+cYDEWGw2JEnvPCTlwxB7t1KUD/g2h0Fc47oMjIJdIfjsXqGyriYbq5Qm1eRttyyIDfGV42HmnL EgOuunFAH+R93V/IUyT2WkjrhQuVfeINN0IS5i3nlbIEPSi0vWjA2k94PlRAiTpnuz6Ki8M1dtx/U I4Yt2vQ7EVZ3hqu9MAYRpaOqEgAa+j/+K8od162eCKj7VbzeQHKUA6Fiu5q8jskWiSzSUweUWXBVL A5989Y6C5Rcpbia0JYQytHy38MZPm9uJlCSwtA8s1glIugltQpl5LPZCpoWdD04RQOzlbZZgBNczj FEU+OuXSdtY6agy766Wr+fcbBFiVtuhcRnq/AkbQOoxk6GxzEauGiajLyZ/hf/yYePKH+C/OGHMwc AohtlyA4ydw80Kyozf6c20w7nGVVBDQ29V54VtBNmW2Ks7OPj3wfYI3jVgJncyrGj1hwah2UjgWKj MxJRZOSMNjJ1iavrkj+/ySUPuGZ9aQh/wNos1o5i7DHPMuIxIwCJhUuERWZI/l7P7fF50Qo/EP7L1 Ojzi2K9P/FGE1ZTGhJdO6nTyMYMH0mu+MqMb4cT782/GAWBjY3iVl6YZaPLqacT0vQmRfxuBP08Jj mQCnhjTmlCATWEnGo2M7M+BSl8p4GIVl57jciFNxaw= From: "=?utf-8?B?5beo6bK4?=" <13207961@qq.com> To: "=?utf-8?B?TWFzYWhpa28gU2F3YWRh?=" Cc: "=?utf-8?B?cGdzcWwtYnVncw==?=" Subject: Re:Re: BUG #17580: use pg_terminate_backend to terminate a wal senderprocess may wait a long time Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_62FB0E54_4E9361B0_65D01972" Content-Transfer-Encoding: 8Bit Date: Tue, 16 Aug 2022 11:26:12 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x X-QQ-mid: xmseszc3-0t1660620372t0sus6lkc List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_62FB0E54_4E9361B0_65D01972 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 VGhhbmtzIQ0KDQpJIHdpbGwgdXBncmFkZSBvdXIgdmVyc2lvbiBhZnRlciBpdCBpcyBmaXhl ZCB0byAxMC4NCg0KDQoNCg0KUmVnYXJkcywNCg0KLS0NCldoYWxlIFNvbmcNCg0KDQoNCg0K DQpPcmlnaW5hbCBFbWFpbA0KDQoNClNlbmRlcjoiTWFzYWhpa28gU2F3YWRhIjwgc2F3YWRh Lm1zaGtAZ21haWwuY29tICZndDs7DQoNClNlbnQgVGltZToyMDIyLzgvMTUgMTI6MDINCg0K VG86IldoYWxlU29uZyI8IDEzMjA3OTYxQHFxLmNvbSAmZ3Q7Ow0KDQpDYyByZWNpcGllbnQ6 InBnc3FsLWJ1Z3MiPCBwZ3NxbC1idWdzQGxpc3RzLnBvc3RncmVzcWwub3JnICZndDs7DQoN ClN1YmplY3Q6UmU6IEJVRyAjMTc1ODA6IHVzZSBwZ190ZXJtaW5hdGVfYmFja2VuZCB0byB0 ZXJtaW5hdGUgYSB3YWwgc2VuZGVycHJvY2VzcyBtYXkgd2FpdCBhIGxvbmcgdGltZQ0KDQoN CkhpLA0KDQpPbiBNb24sIEF1ZyAxNSwgMjAyMiBhdCAxMToyNyBBTSAgPDEzMjA3OTYxQHFx LmNvbSZndDsgd3JvdGU6DQomZ3Q7DQomZ3Q7IEhpIE1hc2FoaWtvLA0KJmd0OyBJIHRoaW5r IG1heWJlIHlvdSBzaG91bGQgdXNlIGZpbHRlci10YWJsZXMgdG8gZmlsdGVyIHRoZSB0ZXN0 IHRhYmxlLCBsaWtlczoNCiZndDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ZmlsdGVy LXRhYmxlcz0icHVibGljLnRlc3Q2NjYiDQomZ3Q7DQoNClRoYW5rcywgSSBjb3VsZCByZXBy b2R1Y2UgdGhpcyBpc3N1ZSB3aXRoIHRoZSBvcHRpb24uIEFuZCBJJ3ZlDQpjb25maXJtZWQg dGhpcyBpc3N1ZSBleGlzdHMgYWxzbyBpbiB0aGUgbGF0ZXN0IG1pbm9yIHZlcnNpb24sIDEw LjIyLA0KYW5kIEhFQUQuDQoNCklmIHRoZSBwbHVnaW4gZmlsdGVycyBvdXQgYWxsIGNoYW5n ZXMsIHRoZXJlIGlzIG5vIHBsYWNlIHRvIGNoZWNrIHRoZQ0KaW50ZXJydXB0aW9ucy4gU28g SSB0aGluayBpdCBtYWtlcyBzZW5zZSB0byBhZGQgQ0hFQ0tfRk9SX0lOVEVSUlVQVFMNCnRv IHRoZSBtYWluIGxvb3Agb2YgcHJvY2Vzc2luZyBsb2dpY2FsIGNoYW5nZS4gSXQgd291bGQg YmUgYmV0dGVyIHRvDQpkbyB0aGF0IG9uIHRoZSBjb3JlLCByYXRoZXIgdGhhbiB0aGUgcGx1 Z2luIHNpZGUuIEkndmUgYXR0YWNoZWQgdGhlDQpwYXRjaC4gSSB0aGluayB3ZSBzaG91bGQg YmFja3BhdGNoIHRvIDEwLg0KDQpSZWdhcmRzLA0KDQotLQ0KTWFzYWhpa28gU2F3YWRhDQpF REI6ICZuYnNwO2h0dHBzOi8vd3d3LmVudGVycHJpc2VkYi5jb20v ------=_NextPart_62FB0E54_4E9361B0_65D01972 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGRpdiBjbGFzcz0icW1ib3giPjxwPjxiciAgLz5UaGFua3MhPC9wPjxwPkkgd2lsbCB1cGdy YWRlIG91ciB2ZXJzaW9uIGFmdGVyIGl0IGlzIGZpeGVkIHRvIDEwLjwvcD48cD48YnIgIC8+ PC9wPjxwPjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogcHJlLXdyYXA7Ij5SZWdhcmRzLDwv c3Bhbj48YnIgIC8+PGJyICAvPjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTogcHJlLXdyYXA7 Ij4tLTwvc3Bhbj48YnIgIC8+PHNwYW4gc3R5bGU9IndoaXRlLXNwYWNlOiBwcmUtd3JhcDsi PldoYWxlIFNvbmc8L3NwYW4+PC9wPjxwPjxiciAgLz48YnIgIC8+PC9wPjxkaXYgY2xhc3M9 InhtX2NvbXBvc2Vfb3JpZ2luX21haWxfY29udGFpbmVyIj48ZGl2IHN0eWxlPSJsaW5lLWhl aWdodDogMzBweDtwb3NpdGlvbjogcmVsYXRpdmU7ZGlzcGxheTogLXdlYmtpdC1ib3g7ZGlz cGxheTogLW1zLWZsZXhib3g7ZGlzcGxheTogZmxleDstd2Via2l0LWJveC1hbGlnbjogY2Vu dGVyOy1tcy1mbGV4LWFsaWduOiBjZW50ZXI7YWxpZ24taXRlbXM6IGNlbnRlcjsiPjxwIHN0 eWxlPSJjb2xvcjogIzk1OURBNjtmb250LXNpemU6IDEycHg7Ij5PcmlnaW5hbCBFbWFpbDwv cD48L2Rpdj48ZGl2IHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiAjRjVGNkY3O3BhZGRpbmc6 IDhweDsiPjxwIHN0eWxlPSJmb250LXNpemU6IDEycHg7bGluZS1oZWlnaHQ6IDIwcHg7Ij48 c3BhbiBzdHlsZT0iY29sb3I6ICM1QzYxNjY7Ij5TZW5kZXI6PC9zcGFuPjxzcGFuIHN0eWxl PSJjb2xvcjogYmxhY2s7Ij4iTWFzYWhpa28gU2F3YWRhIjwvc3Bhbj48c3BhbiBzdHlsZT0i Y29sb3I6ICM5NTlEQTY7Ij4mbHQ7IHNhd2FkYS5tc2hrQGdtYWlsLmNvbSAmZ3Q7Ozwvc3Bh bj48L3A+PHAgc3R5bGU9ImZvbnQtc2l6ZTogMTJweDtsaW5lLWhlaWdodDogMjBweDsiPjxz cGFuIHN0eWxlPSJjb2xvcjogIzVDNjE2NjsiPlNlbnQgVGltZTo8L3NwYW4+PHNwYW4gc3R5 bGU9ImNvbG9yOiBibGFjazsiPjIwMjIvOC8xNSAxMjowMjwvc3Bhbj48L3A+PHAgc3R5bGU9 ImZvbnQtc2l6ZTogMTJweDtsaW5lLWhlaWdodDogMjBweDsiPjxzcGFuIHN0eWxlPSJjb2xv cjogIzVDNjE2NjsiPlRvOjwvc3Bhbj48c3BhbiBzdHlsZT0iY29sb3I6IGJsYWNrOyI+Ildo YWxlU29uZyI8L3NwYW4+PHNwYW4gc3R5bGU9ImNvbG9yOiAjOTU5REE2OyI+Jmx0OyAxMzIw Nzk2MUBxcS5jb20gJmd0Ozs8L3NwYW4+PC9wPjxwIHN0eWxlPSJmb250LXNpemU6IDEycHg7 bGluZS1oZWlnaHQ6IDIwcHg7Ij48c3BhbiBzdHlsZT0iY29sb3I6ICM1QzYxNjY7Ij5DYyBy ZWNpcGllbnQ6PC9zcGFuPjxzcGFuIHN0eWxlPSJjb2xvcjogYmxhY2s7Ij4icGdzcWwtYnVn cyI8L3NwYW4+PHNwYW4gc3R5bGU9ImNvbG9yOiAjOTU5REE2OyI+Jmx0OyBwZ3NxbC1idWdz QGxpc3RzLnBvc3RncmVzcWwub3JnICZndDs7PC9zcGFuPjwvcD48cCBzdHlsZT0iZm9udC1z aXplOiAxMnB4O2xpbmUtaGVpZ2h0OiAyMHB4OyI+PHNwYW4gc3R5bGU9ImNvbG9yOiAjNUM2 MTY2OyI+U3ViamVjdDo8L3NwYW4+PHNwYW4gc3R5bGU9ImNvbG9yOiBibGFjazsiPlJlOiBC VUcgIzE3NTgwOiB1c2UgcGdfdGVybWluYXRlX2JhY2tlbmQgdG8gdGVybWluYXRlIGEgd2Fs IHNlbmRlcnByb2Nlc3MgbWF5IHdhaXQgYSBsb25nIHRpbWU8L3NwYW4+PC9wPjwvZGl2Pjxi ciAgLz5IaSw8YnIgIC8+PGJyICAvPk9uIE1vbiwgQXVnIDE1LCAyMDIyIGF0IDExOjI3IEFN ICAmbHQ7MTMyMDc5NjFAcXEuY29tJmd0OyB3cm90ZTo8YnIgIC8+Jmd0OzxiciAgLz4mZ3Q7 IEhpIE1hc2FoaWtvLDxiciAgLz4mZ3Q7IEkgdGhpbmsgbWF5YmUgeW91IHNob3VsZCB1c2Ug ZmlsdGVyLXRhYmxlcyB0byBmaWx0ZXIgdGhlIHRlc3QgdGFibGUsIGxpa2VzOjxiciAgLz4m Z3Q7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwO2ZpbHRlci10YWJsZXM9InB1YmxpYy50 ZXN0NjY2IjxiciAgLz4mZ3Q7PGJyICAvPjxiciAgLz5UaGFua3MsIEkgY291bGQgcmVwcm9k dWNlIHRoaXMgaXNzdWUgd2l0aCB0aGUgb3B0aW9uLiBBbmQgSSd2ZTxiciAgLz5jb25maXJt ZWQgdGhpcyBpc3N1ZSBleGlzdHMgYWxzbyBpbiB0aGUgbGF0ZXN0IG1pbm9yIHZlcnNpb24s IDEwLjIyLDxiciAgLz5hbmQgSEVBRC48YnIgIC8+PGJyICAvPklmIHRoZSBwbHVnaW4gZmls dGVycyBvdXQgYWxsIGNoYW5nZXMsIHRoZXJlIGlzIG5vIHBsYWNlIHRvIGNoZWNrIHRoZTxi ciAgLz5pbnRlcnJ1cHRpb25zLiBTbyBJIHRoaW5rIGl0IG1ha2VzIHNlbnNlIHRvIGFkZCBD SEVDS19GT1JfSU5URVJSVVBUUzxiciAgLz50byB0aGUgbWFpbiBsb29wIG9mIHByb2Nlc3Np bmcgbG9naWNhbCBjaGFuZ2UuIEl0IHdvdWxkIGJlIGJldHRlciB0bzxiciAgLz5kbyB0aGF0 IG9uIHRoZSBjb3JlLCByYXRoZXIgdGhhbiB0aGUgcGx1Z2luIHNpZGUuIEkndmUgYXR0YWNo ZWQgdGhlPGJyICAvPnBhdGNoLiBJIHRoaW5rIHdlIHNob3VsZCBiYWNrcGF0Y2ggdG8gMTAu PGJyICAvPjxiciAgLz5SZWdhcmRzLDxiciAgLz48YnIgIC8+LS08YnIgIC8+TWFzYWhpa28g U2F3YWRhPGJyICAvPkVEQjogJm5ic3A7aHR0cHM6Ly93d3cuZW50ZXJwcmlzZWRiLmNvbS88 YnIgIC8+PGJyICAvPjxzcGFuIGNsYXNzPSJ4bV9jb21wb3NlX29yaWdpbl9tYWlsX2NvbnRh aW5lcl9zaWduIiBzdHlsZT0iZGlzcGxheTogbm9uZTsiPjwvc3Bhbj48L2Rpdj48L2Rpdj4= ------=_NextPart_62FB0E54_4E9361B0_65D01972--