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.96) (envelope-from ) id 1w3pk6-001aWy-0O for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Mar 2026 06:23:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3pk4-0099cF-2J for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Mar 2026 06:23:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w3pgy-0096OF-39 for pgsql-bugs@lists.postgresql.org; Sat, 21 Mar 2026 06:20:13 +0000 Received: from out162-62-57-64.mail.qq.com ([162.62.57.64]) by magus.postgresql.org with utf8esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w3pgt-00000000Iav-1BH1 for pgsql-bugs@lists.postgresql.org; Sat, 21 Mar 2026 06:20:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1774073998; bh=0YlBsaE6EdFmZlEcke04PeYWp1Xidt0shRp14pyCBX0=; h=From:To:Cc:Subject:Date:References:In-Reply-To; b=SgwWfINcwVKTRjJ2auZDfdem3IXFW6TqJpHQBYjYtCsjFGmLItwf5fTu7JSxokR7E wT3oV4fSWZOGGnOJ+Neu753c5YeZSsdRmAOamchRhdoqHVCTdTqIt59qn+5S1WKr+l wzFlx5Cy1aOfmknC/MrjV0ohCEhuinERY3RrT65w= X-QQ-XMRINFO: OWPUhxQsoeAVwkVaQIEGSKwwgKCxK/fD5g== X-QQ-XMAILINFO: NVS1RghF1TN+LRxrhDMRL61MDXsafWkMsJbOMh/72Wyrf+IyjjNRH0E/mdFD/K +a3dtx8dWF+92/jqw0ZzT3dh4ad3KGMCkfjrQ3clGiIj8pw/K2jS82SfePKMud+f4XNOGMlfASm7Z lHFJxYFyC3JPmkjfuwAiJ5kaO9UgqDUH4E9L2jPCt0wyLAcvF0oyLEjyVSAay60jRdzy0D0Hep9pA nI1OLaXWxtTQt9ite0I1LNbCENRx/k6v6yWYc2RrebJg0wW/txPCNLPxmJn+Wy8xu3Rr+lc7FGGE3 OpftEHQsMcmP9j0MMWleMQs2zwGiWr96cxarXNh9Y/cRCbB1SKvk0dvmUoPSlyEx7x6aR2aAv8FYC kt+zJFPltydPO6uwkqdwwGbn1BPzjpXxOFyQrU0AZPkZjDvxX6EpyvOFv0fGaVMmDazejoswjQxkv aahG4P5moiK/qew8p2dyBfW7yyt/n/xN2XTRT5njH/uVJdcsJhR4JDjdIBPO5WQ0aNRR81HAjtEmo 0OMRVGJfYLUCwhO/tr2BYCy4iZqmlM25KRIKl0+8JE1kCy9Qk6hTgzK3y8c/OsxhA+frv6U1SbGt2 a3uuKEIYjkNV42ErHXWFve37excw8Sx4dCgf9IQoFrSi6JhwGRWZiR+rJECBaVL9g+LoQOWc3p/4Z GCEAa2FxkMD3rv9wPjux3tQEk/aIunGeNLvag++VYF9xCMyJd64cdTCfiKvyYuH06FjwMyBvjvB0m B5Fnu5rKU+DmmNis7EccnmHMQUaUd4wtmOy3wl9P+7KtDrAKGJDt2OoXSu3GCI2wmDA++yTxLJH8q TAZ1raidDs8GZZQraGQg4SRWX5AZy/jcQeoKxoXONZBe6RWvpWWv6p8O47WEfhzZcgujS0dyqlqeH ygOIa8F2Cuufci/a0udqOLUE0VRb/hBwuBQW5/F4jb/AJiEeWSGL5Yq3LcAkvuDAxTAP0k/ikRMGD uXWDwTqhFI4g/MfEU/VmcFIfuLcIEiXN29kIecSMOItyYeJoemLrisAXQ2Hmnmy4BB8BHZWT5sr2A f1H/O4UnjoJEnyKgUeuwUJluDof6y8m7KOBxoUa1IJTuKECVE366+jkk3yqj/2xoJk2K3 From: "=?utf-8?B?Y2NhNTUwNw==?=" To: "=?utf-8?B?c3VyeWEgcG9vbmRsYQ==?=" Cc: "=?utf-8?B?UmFmaWEgU2FiaWg=?=" , "=?utf-8?B?R2l1bGlhbm8gR2FnbGlhcmRp?=" , "=?utf-8?B?cGdzcWwtYnVncw==?=" Subject: Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY Mime-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Date: Sat, 21 Mar 2026 14:19:56 +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 References: <40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv> In-Reply-To: X-QQ-mid: xmseza62-0t1774073996t2lc0lfo2 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgU3VyeWEsDQoNCj4gRm9yIGlzc3VlIDEsIG15IGZpeCByZW1vdmVzIHRoZSBJUyBOT1Qg TlVMTCBndWFyZCBmcm9tIHRoZSBwcmUtY2hlY2sgc28NCj4gdGhhdCAqPSBjYW4gZGV0ZWN0 IGFsbCBkdXBsaWNhdGUgcm93cywgaW5jbHVkaW5nIHRob3NlIGNvbnRhaW5pbmcgTlVMTHMu DQo+IChOb3RlOiBUaGUgc2VtYW50aWNzIG9mICo9IMKgaGFzIGFsd2F5cyB0cmVhdGVkIE5V TEwgYXMgZXF1YWwgdG8gTlVMTC4pDQo+IA0KPiBUaGUgcmVhc29uaW5nIGlzIHN0cmFpZ2h0 Zm9yd2FyZDogdGhlIEpPSU4gdXNlcyAqPSB0byBtYXRjaCBuZXdkYXRhIHJvd3MNCj4gYWdh aW5zdCBNViByb3dzLiBJZiBuZXdkYXRhIGNvbnRhaW5zIHR3byAqPS1lcXVhbCByb3dzLCBi b3RoIHdvdWxkIG1hdGNoDQo+IHRoZSBzYW1lIE1WIHJvdyBpbiB0aGUgSk9JTiwgcHJvZHVj aW5nIGEgd3JvbmcgZGlmZi4gVGhlIHByZS1jaGVjayBtdXN0DQo+IHRoZXJlZm9yZSB1c2Ug dGhlIHNhbWUgKj0gc2VtYW50aWNzIHRvIGNhdGNoIGV4YWN0bHkgdGhvc2UgZHVwbGljYXRl c8KgDQo+IHdoaWNoIGlzIHdoYXQgbXkgZml4IGRvZXMgYnkgcmVtb3ZpbmcgdGhlIElTIE5P VCBOVUxMIGd1YXJkLg0KPiBUaGUgSVMgTk9UIE5VTEwgZ3VhcmQgd2FzIHRoZSBidWcgYXMg aXQgd2FzIGhpZGluZyByZWFsIGR1cGxpY2F0ZXMgZnJvbSBkZXRlY3Rpb24uDQoNCklmIEkg dW5kZXJzdGFuZCBjb3JyZWN0bHksIHlvdXIgZml4IHdpbGwgYnJlYWsgdGhlIGZvbGxvd2lu ZyBjYXNlIHdoaWNoIHdvcmtzIHdlbGwgY3VycmVudGx5Og0KDQpDUkVBVEUgVEFCTEUgdCAo YSBpbnQsIGIgaW50KTsNCklOU0VSVCBJTlRPIHQgVkFMVUVTIChudWxsLCBudWxsKTsNCkNS RUFURSBNQVRFUklBTElaRUQgVklFVyBtIEFTIFNFTEVDVCAqIEZST00gdDsNCkNSRUFURSBV TklRVUUgSU5ERVggT04gbShhKTsNCklOU0VSVCBJTlRPIHQgVkFMVUVTIChudWxsLCBudWxs KTsNClJFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVOVExZIG07DQoNCllvdXIg Zml4IHdpbGwgcmVwb3J0IGFuIGVycm9yIGJlY2F1c2Ugb2YgdGhlIHR3byAobnVsbCwgbnVs bCkgcm93cy4gT24gbWFzdGVyLCB0aGlzIGNhc2UNCndvcmtzIHdlbGwgYmVjYXVzZSBvZiB0 aGUgam9pbiBjb25kaXRpb24gIm12LmEgPSBuZXdkYWRhLmEiIHdoaWNoIGNvbnNpZGVycyB0 d28NCk5VTExzIG5vdCBlcXVhbCwgc28gd2Ugd2lsbCBnZXQgYSBjb3JyZWN0IGRpZmYgdGFi bGUuDQoNCj4gWW91ciBhcHByb2FjaCBsZWF2ZXMgdGhlIHByZS1jaGVjayB1bmNoYW5nZWQg YW5kIGluc3RlYWQgcmVwbGFjZXMgKj0gaW4NCj4gdGhlIEpPSU4gd2l0aCByZWNvcmRfaW1h Z2VfZXFfdmFyaWFudCAoTlVMTCAhPSBOVUxMKS4gSSBzZWUgdHdvIGNvbmNlcm5zOg0KPiAx LiByZWNvcmRfaW1hZ2VfZXFfdmFyaWFudCBhcHBsaWVzIE5VTEwgIT0gTlVMTCBnbG9iYWxs eSB0byBhbGwgcm93cyBpbg0KPiDCoCDCoHRoZSBKT0lOLCBub3QganVzdCBkdXBsaWNhdGUg b25lcy4gVGhpcyBtZWFucyBhbnkgdW5jaGFuZ2VkIHJvdw0KPiDCoCDCoGNvbnRhaW5pbmcg YW55IE5VTEwgaW4gYW55IGNvbHVtbiB3aWxsIG5ldmVyIG1hdGNoIGl0cyBjb3VudGVycGFy dA0KPiDCoCDCoGR1cmluZyB0aGUgSk9JTiwgY2F1c2luZyBhIERFTEVURSArIElOU0VSVCBm b3IgdGhhdCByb3cgb24gZXZlcnkNCj4gwqAgwqByZWZyZXNoIGV2ZW4gd2hlbiB0aGUgZGF0 YSBoYXMgbm90IGNoYW5nZWQuIFRoZSBvcmlnaW5hbCBpc3N1ZSAyIHdhcw0KPiDCoCDCoHNw ZWNpZmljYWxseSBhYm91dCBudWxsYWJsZSBpbmRleGVkIGNvbHVtbnMsIHlvdXIgZml4IGV4 dGVuZHMgdGhlDQo+IMKgIMKgcGVyZm9ybWFuY2UgcHJvYmxlbSB0byBhbGwgbnVsbGFibGUg Y29sdW1ucyBhbnl3aGVyZSBpbiB0aGUgcm93LA0KPiDCoCDCoHdoaWNoIG1ha2VzIHRoZSBw ZXJmb3JtYW5jZSB3b3JzZSB0aGFuIGlzc3VlwqAyLg0KDQpZZWFoLCB5b3UncmUgcmlnaHQu IEFueSByb3cgY29udGFpbmluZyBhbnkgTlVMTCBpbiBhbnkgY29sdW1uIHdpbGwgZ2V0IGlu dG8gdGhlDQpkaWZmIHRhYmxlLiBCdXQgaXQncyBmb3IgY29ycmVjdG5lc3MuIE1heWJlIHVz ZXIgc2hvdWxkIGF2b2lkIHVzaW5nIENPTkNVUlJFTlRMWQ0Kd2l0aCBhIGxvdCBvZiByb3dz IGNvbnRhaW5pbmcgTlVMTC4NCg0KPiAyLiBUaGUgZXJyb3Igc3VyZmFjZWQgYmVjb21lcyBh IHVuaXF1ZV92aW9sYXRpb24gZnJvbSB0aGUgaW5kZXggcmF0aGVyDQo+IMKgIMKgdGhhbiB0 aGUgZXhwbGljaXQgImNvbnRhaW5zIGR1cGxpY2F0ZSByb3dzIiBtZXNzYWdlLCB3aGljaCBp cyBoYXJkZXINCj4gwqAgwqBmb3IgdXNlcnMgdG8gZGlhZ25vc2UuDQoNCkkgZG9uJ3QgdGhp bmsgaXQncyBhIGJpZyBpc3N1ZS4NCg0KLS0NClJlZ2FyZHMsDQpDaGFuZ0FvIENoZW4NCg==