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 1khrNj-000145-W2 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Nov 2020 09:46:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1khrNi-0008DC-P1 for pgsql-admin@arkaria.postgresql.org; Wed, 25 Nov 2020 09:46:34 +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 1khrNi-0008D5-Cw for pgsql-admin@lists.postgresql.org; Wed, 25 Nov 2020 09:46:34 +0000 Received: from forward105p.mail.yandex.net ([77.88.28.108]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1khrNg-00050r-0O for pgsql-admin@postgresql.org; Wed, 25 Nov 2020 09:46:33 +0000 Received: from forward102q.mail.yandex.net (forward102q.mail.yandex.net [IPv6:2a02:6b8:c0e:1ba:0:640:516:4e7d]) by forward105p.mail.yandex.net (Yandex) with ESMTP id CD6484D42D16 for ; Wed, 25 Nov 2020 12:46:29 +0300 (MSK) Received: from mxback2q.mail.yandex.net (mxback2q.mail.yandex.net [IPv6:2a02:6b8:c0e:40:0:640:9c8c:4946]) by forward102q.mail.yandex.net (Yandex) with ESMTP id C95C67F20002 for ; Wed, 25 Nov 2020 12:46:29 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback2q.mail.yandex.net (mxback/Yandex) with ESMTP id defTVEWXmi-kTa0kOMg; Wed, 25 Nov 2020 12:46:29 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1606297589; bh=MGFpfDbP1EirQnGXhsPnhacguj7jEE1V2FWeaW3di+g=; h=Message-Id:Date:Subject:To:From; b=XqGfRu04ib+Wi5TQyac998MvBpdvBiYooTazPg9Tw4Jh0OszJ+PolXk2sHy+HJQsq 9wbZ6EE2tIfN1i9B311OvOzD35kRRXAGbVhKDIROKF29kTvz7YjnAUQ62Rq2Nn94WJ Y/D6l+jicuz+YPJ9hLaHPKBeW+BgIOcLXBXJAoHU= Authentication-Results: mxback2q.mail.yandex.net; dkim=pass header.i=@yandex.ru Received: by vla5-a235cc842fef.qloud-c.yandex.net with HTTP; Wed, 25 Nov 2020 12:46:29 +0300 From: =?utf-8?B?0JjQs9C+0YDRjCDQktGL0YHQutC+0YDQutC+?= Envelope-From: vyskorko-igor@yandex.ru To: "pgsql-admin@postgresql.org" Subject: Hot standby with hot_standny_feedback enabled: cancelling statement issues MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 25 Nov 2020 16:46:29 +0700 Message-Id: <6184231606295846@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSE8YnIgLz7CoDwvZGl2PjxkaXY+SSdtIHRyeWluZyB0byBjb25maWd1cmUgaG90IHN0 YW5kYnkgcmVwbGljYSBmb3IgYW5hbHl0aWNzIGFuZCBzaW1wbGUgYmFja3VwIHB1cnBvc2VzLiBT bywgSSBoYXZlIGxvbmcgcXVlcmllcyB3aGljaCBjb25zdGFudGx5IGNhbmNlbGxlZCB3aXRob3V0 IHByb3BlciBjb25maWd1cmluZy48YnIgLz5JIGRvIG5vdCB3YW50IGxhcmdlIGxhZyBvbiByZXBs aWNhIChtb3JlIHRoYW4gMzAgbWlucykgc28gc2V0dGluZyBtYXhfc3RhbmRieV9zdHJlYW1pbmdf ZGVsYXkgdG8gLTEgaXMgbm90IG15IGNob2ljZS4gwqBJIGhhdmUgdG8gYXZvaWQgbGFyZ2UgbGFn IGJlY2F1c2Ugb2YgYW5hbHl0aWMgcXVlcmllcyB3aGljaCBtdXN0IGJlIHJ1biBvbiBhbG1vc3Qg ZnJlc2ggY29weSBvZiBkYXRhLjwvZGl2PjxkaXY+SSBmb3VuZCB0aGUgcGFuYWNlYSAoSSB0aG91 Z2h0IEkgZm91bmQgYWN0dWFsbHkpIGluIHNldHRpbmcgaG90X3N0YW5kYnlfZmVlZGJhY2sgPSBv biAoSSBrbm93IGFib3V0IHBvc3NpYmxlIG1hc3RlciBibG9hdGluZykgYnV0IGl0IGFsc28gZG9l c24ndCBoZWxwLjxiciAvPkp1c3QgdG8gY2xhcmlmeSBhYm91dCAic2ltcGxlIGJhY2t1cCBwdXJw b3NlcyI6IGl0IG1lYW5zIHJ1biBwZ19kdW1wIGluIGRhaWx5IGJhc2lzLiBPdXIgZGF0YWJhc2Ug aXMgYWJvdXQgMjUwR2I8YnIgLz7CoDxkaXY+MiB0ZXN0IHJ1biBvZiBwZ19kdW1wIGZhaWxlZCB3 aXRoOjxkaXY+cGdfZHVtcDogRHVtcGluZyB0aGUgY29udGVudHMgb2YgdGFibGUgInRhYmxlIiBm YWlsZWQ6IFBRZ2V0UmVzdWx0KCkgZmFpbGVkLjwvZGl2PjxkaXY+cGdfZHVtcDogRXJyb3IgbWVz c2FnZSBmcm9tIHNlcnZlcjogRVJST1I6IMKgY2FuY2VsaW5nIHN0YXRlbWVudCBkdWUgdG8gY29u ZmxpY3Qgd2l0aCByZWNvdmVyeTwvZGl2PjxkaXY+REVUQUlMOiDCoFVzZXIgd2FzIGhvbGRpbmcg YSByZWxhdGlvbiBsb2NrIGZvciB0b28gbG9uZy48L2Rpdj48ZGl2PnBnX2R1bXA6IFRoZSBjb21t YW5kIHdhczogQ09QWS4uLjxiciAvPsKgPGRpdj5wb3N0Z3Jlcz0jIHNlbGVjdCAqIGZyb20gcGdf c3RhdF9kYXRhYmFzZV9jb25mbGljdHMgOzwvZGl2PjxkaXY+wqAgwqBkYXRpZCDCoCB8IMKgIMKg ZGF0bmFtZSDCoCDCoHwgY29uZmxfdGFibGVzcGFjZSB8IGNvbmZsX2xvY2sgfCBjb25mbF9zbmFw c2hvdCB8IGNvbmZsX2J1ZmZlcnBpbiB8IGNvbmZsX2RlYWRsb2NrwqA8L2Rpdj48ZGl2Pi0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLTwvZGl2Pjxk aXY+wqAgwqAgwqAxMjQ0NSB8IGRibmFtZSDCoCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAwIHwgwqAgwqAgwqAgwqAgwqAyIHwgwqAgwqAgwqAgwqAgwqAgwqAgwqAwIHwgwqAgwqAgwqAg wqAgwqAgwqAgwqAgMCB8IMKgIMKgIMKgIMKgIMKgIMKgIMKgMDwvZGl2PjxkaXY+PGJyIC8+Tm90 IHN1cmUgYWJvdXQgd2hhdCBraW5kIG9mIGxvY2sgd2FzIGhvbGRpbmcgdG9vIGxvbmcuLi48YnIg Lz48YnIgLz5TbywgbXkgcXVlc3Rpb25zIGFyZTo8YnIgLz4xLiBXaHkgImhvdF9zdGFuZGJ5X2Zl ZWRiYWNrID0gb24iIGlzIG5vdCBoZWxwaW5nPzxiciAvPjIuIFdoYXQgaXMgcHJvcGVyIHdheSB0 byB1c2UgcmVwbGljYSBmb3IgdGFza3MgYXMgbWluZT88YnIgLz48YnIgLz5UaGFua3M8L2Rpdj48 L2Rpdj48L2Rpdj48YnIgLz48YnIgLz5PdXIgY3VycmVudCBzZXR1cDo8ZGl2PjxkaXY+cG9zdGdy ZXM9IyBzZWxlY3QgdmVyc2lvbigpOzwvZGl2PjxkaXY+wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAgwqAg wqAgwqAgwqAgwqAgwqAgdmVyc2lvbiDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDC oCDCoDwvZGl2PjxkaXY+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPC9kaXY+PGRpdj7CoFBvc3RncmVT UUwgOS42LjE1IG9uIHg4Nl82NC1wYy1saW51eC1nbnUgKFVidW50dSA5LjYuMTUtMS5wZ2RnMTgu MDQrMSksIGNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDcuNC4wLTF1YnVudHUxfjE4LjA0LjEpIDcu NC4wLCA2NC1iaXQ8L2Rpdj48ZGl2PigxIHJvdyk8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5wb3N0 Z3Jlcz0jIHNlbGVjdCBuYW1lLCBzZXR0aW5nLCB1bml0IGZyb20gcGdfc2V0dGluZ3Mgd2hlcmUg Y2F0ZWdvcnkgPSAnUmVwbGljYXRpb24gLyBTdGFuZGJ5IFNlcnZlcnMnO8KgPC9kaXY+PGRpdj7C oCDCoCDCoCDCoCDCoCDCoCDCoG5hbWUgwqAgwqAgwqAgwqAgwqAgwqAgfCBzZXR0aW5nIHwgdW5p dMKgPC9kaXY+PGRpdj4tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tKy0t LS0tLTwvZGl2PjxkaXY+wqBob3Rfc3RhbmRieSDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoHwg b24gwqAgwqAgwqB8wqA8L2Rpdj48ZGl2PsKgaG90X3N0YW5kYnlfZmVlZGJhY2sgwqAgwqAgwqAg wqAgfCBvbiDCoCDCoCDCoHzCoDwvZGl2PjxkaXY+wqBtYXhfc3RhbmRieV9hcmNoaXZlX2RlbGF5 IMKgIMKgfCA5MzAwMDAgwqB8IG1zPC9kaXY+PGRpdj7CoG1heF9zdGFuZGJ5X3N0cmVhbWluZ19k ZWxheSDCoHwgOTAwMDAwIMKgfCBtczwvZGl2PjxkaXY+wqB3YWxfcmVjZWl2ZXJfc3RhdHVzX2lu dGVydmFsIHwgMTAgwqAgwqAgwqB8IHM8L2Rpdj48ZGl2PsKgd2FsX3JlY2VpdmVyX3RpbWVvdXQg wqAgwqAgwqAgwqAgfCA2MDAwMCDCoCB8IG1zPC9kaXY+PGRpdj7CoHdhbF9yZXRyaWV2ZV9yZXRy eV9pbnRlcnZhbCDCoHwgNTAwMCDCoCDCoHwgbXM8L2Rpdj48ZGl2Pig3IHJvd3MpPC9kaXY+PC9k aXY+PC9kaXY+PGRpdj7CoDwvZGl2Pg==