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 1wV8jv-001ilO-38 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 14:08:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wV8ju-006uCa-2Q for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 14:08:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wV8ju-006uCS-05 for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 14:08:06 +0000 Received: from smtpbg150.qq.com ([18.132.163.193]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wV8jh-00000001FWj-0RuV for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 14:08:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1780582041; bh=cZYrINJiiBtqAiFcIzyo1qJZmRf+VFR3psTOP5Tq2rY=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=lNkf3ZbP1pJeMnQgggNsncDK6el0EL7Mo/ze4itP/bDVEPjRH6SKFPWQ+PBg4UUqR cAroBtFncsJ4UTzCeO97jBlYFTtRf+QAlXnvMsZOiIGJykr1Zg1PmcqBJWcVpz8OpV GbHCkN3OxxVa+tlru8fv3GXPbQKwhUffqqVZNHKo= EX-QQ-RecipientCnt: 5 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: D4aqtcRDiqSY5Yz43EA+gSWG4VUqgbjQfklQaTpHbps= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: JS9WWlDGt7G7ti3ChN/5Ddi+aJi7XIL9cz2Jb1kcvWU= X-Originating-IP: 112.10.2.143 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1780582040tb146c8af From: "=?ISO-8859-1?B?emVuZ21hbg==?=" To: "=?ISO-8859-1?B?QXNodXRvc2ggQmFwYXQ=?=" Cc: "=?ISO-8859-1?B?SnVud2FuZyBaaGFv?=" , "=?ISO-8859-1?B?cGdzcWwtaGFja2Vycw==?=" , "=?ISO-8859-1?B?UGV0ZXIgRWlzZW50cmF1dA==?=" , "=?ISO-8859-1?B?QXl1c2ggVGl3YXJp?=" Subject: Re: (SQL/PGQ) cache lookup failed for label Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 Date: Thu, 4 Jun 2026 22:07:19 +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: In-Reply-To: X-QQ-ReplyHash: 947339270 X-BIZMAIL-ID: 12254992967055969983 X-Address-Ticket: version=;type=;ticket_id=;id_list=;display_name=;session_id=; X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Thu, 04 Jun 2026 22:07:20 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz4b-0 X-QQ-XMAILINFO: NtJ3KPVhtqciYQLPitDBfPZDHMRhi7ATDLkVmxkdlmIV+5vGAahfBk50 QciJ0Q7D61a5jNkjIW1BGEi/63sxl+uUTXMlK28Hny+yVG+HMsL6m8GfssmyRS3yzsqDp6J z+4rFS+a1l+FPeypMbyKa776Qhswckd6wgisGm6B78xfkcugPAP8TJ9ny5PuODncEzjqMVD K8np+vFo91rhyR/GAFa74Ps+fCYl7+1UJ7yEUK8eGgVz4BPl3ir+ascNhEnMcL+oYG1JTl/ ID8oSLAmDm+noHWnaOx5TJ+ZUmgzUFw99sHjY2IXay2Pi682uFoE40XNejabI9wiWF2y05y qg3tYJtTe/yG8uKuIiSlj9b5eQYEsGHD9LVsyXnsTVfu0IJI+OEJmJEpx0O9Asd2cXI5NFY JBENd/QVnYmvWyw9UdR0Q+I522J2BSSjkLKvzDX+1xpD943ASwAjTnIXHGv7eWrMyNFmtRT bZqMIkFLd68aMlXv/DAXIhMJOPWbOeVpvHtd2K4NlXvl3W6LrPMkv6/QZtORraPHsb9UmUq vrLrlnR8CuyNrPSaJuRYqHFs8qFsnmtlSL6NgRt4ebUERAg/7XANthrwiPVQGSJrO65NKYu tRARKyruT0j2ztkRnCK8bbn2QWUAcLVROLDU4KBAWCD3PIrJwMoQVjZw2f9cUWJjgRNGkF7 49RANW2Gioj6EMVmH2qEdtUWIbbWSUH3XfDP2dseYtlKSCeiafOqqyJHOuDXClPvyIj+s6I daCpWxF7ggFRoaU+Ne1c+NJTEztYgLC0R9N3PadBhk9zjc3l5iFNz9iti0Nj2S7a3xbSRas 5Dtj0U4xulYWTfBNJ0KNLaoXtS3O4LbGKshT9yMN2PKi3vIYJxivJMmutVcG+OODh2w1G5r iA3z7omsjiCHMwcieM9seaq9dLrepFEWlDRkKUwFDkcIVJrOciwsKgpsSCIYB+ju1A90raL 7yh39WXfaXDtxzPHaHGPIS8dihXt+1STddj+dIjDjnM5F4uZiF2pgWDNtbOES2WV77v8zgx Fo3NGK48HVrq8sMUdGY+0UJmd2aFBFxtG+whg+eNMeKmrqmu0GlfSCz0bBuAt+QDULV9/Yh c8oJitZWxBAGNEJZGlvnPM= X-QQ-XMRINFO: NS+P29fieYNwqS3WCnRCOn9D1NpZuCnCRA== X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBGb3Igbm93IEkgaGF2ZSBhZGRlZCBhIHRlc3QgY2FzZSBleGhpYml0aW5nIHRoaXMgYmVo YXZpb3VyLiBJZiB3ZQ0KPiBjb21taXQgdGhlIHRlc3QsIHNvbWVib2R5IHdobyBjb21lcyBh Y3Jvc3MgdGhpcyBiZWhhdmlvdXIgd2lsbCBrbm93DQo+IHdoeSB0aGUgY3VycmVudCBiZWhh dmlvdXIgaXMgdGhlIHdheSBpdCBpcyBhbmQgd2hhdCdzIHRoZSB3YXkgZm9yd2FyZC4NCj4g QnV0IGlmIHdlIGRvbid0IGNvbW1pdCBpdCwgd2hpY2ggaXMgb2ssIHRoZXkgd2lsbCBjb25z aWRlciB0aGlzIGFzDQo+IGJ1Z2d5IGJlaGF2aW91ciBhbmQgcmVwb3J0IGl0LiBJIGFtIGZp bmUgZWl0aGVyIHdheS4NCj4gDQo+IEFzIEkgbWVudGlvbmVkIGVhcmxpZXIsIEkgYW0gY3Jl YXRpbmcgcGF0Y2hlcyBmb3IgYWxsIG91dHN0YW5kaW5nDQo+IGlzc3VlcyBmcm9tIHRoZSBz YW1lIGJyYW5jaC4gU28gdGhlIHBhdGNoZXMgYXR0YWNoZWQgaGVyZSBkbyBub3Qgc3RhcnQN Cj4gZnJvbSAwMDAxLCBidXQgdGhleSBhcHBseSB3aXRoIGdpdCBhbSBvbiB0aGUgbGF0ZXN0 IG1hc3RlciBmb3IgbWUNCj4gd2l0aG91dCBhbnkgcHJvYmxlbS4NCj4gMDAwNSAtIGZpeGVz IGBjYWNoZSBsb29rdXAgZmFpbGVkIGZvciBsYWJlbGANCj4gMDAwNiAtIGZpeGVzIGVtcHR5 IGxhYmVsIGV4cHJlc3Npb24gYW5kIHZpZXcgYmVoYXZpb3VyDQo+IDAwMDcgLSBpc3N1ZSB3 aXRoIGxhYmVscyBzaGFyZWQgYnkgdmVydGV4IGFuZCBlZGdlcw0KDQpIaSBBc2h1dG9zaCwN Cg0KSSBhcHBsaWVkIGFuZCB0ZXN0ZWQgdGhlIHYyMDI2MDYwMSBwYXRjaGVzIG9uIHRvcCBv ZiBtYXN0ZXIsIGxvb2tzIGdvb2QuDQoNCk9uZSB0aGluZyBJIG5vdGljZWQgdGhvdWdoIC0t IFJlbW92ZVJlbGF0aW9ucygpIGluIHByb3BncmFwaGNtZHMuYw0KY2xlYW5zIHVwIG9ycGhh bmVkIHBnX3Byb3BncmFwaF9wcm9wZXJ0eSBlbnRyaWVzLCBidXQgdGhlIGNvbmRpdGlvbg0K ZG9lc24ndCBpbmNsdWRlIGRyb3BfbGFiZWw6DQoNCmBgYGRpZmYNCmRpZmYgLS1naXQgYS9z cmMvYmFja2VuZC9jb21tYW5kcy9wcm9wZ3JhcGhjbWRzLmMgYi9zcmMvYmFja2VuZC9jb21t YW5kcy9wcm9wZ3JhcGhjbWRzLmMNCmluZGV4IGNjNTE2ZTI3MDIwLi43YzhmMzk3YWZiZiAx MDA2NDQNCi0tLSBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3Byb3BncmFwaGNtZHMuYw0KKysr IGIvc3JjL2JhY2tlbmQvY29tbWFuZHMvcHJvcGdyYXBoY21kcy5jDQpAQCAtMTYzOCw3ICsx NjM4LDcgQEAgQWx0ZXJQcm9wR3JhcGgoUGFyc2VTdGF0ZSAqcHN0YXRlLCBjb25zdCBBbHRl clByb3BHcmFwaFN0bXQgKnN0bXQpDQogICAgICAgIH0NCiANCiAgICAgICAgLyogUmVtb3Zl IGFueSBvcnBoYW5lZCBwZ19wcm9wZ3JhcGhfcHJvcGVydHkgZW50cmllcyAqLw0KLSAgICAg ICBpZiAoc3RtdC0+ZHJvcF9wcm9wZXJ0aWVzIHx8IHN0bXQtPmRyb3BfdmVydGV4X3RhYmxl cyB8fCBzdG10LT5kcm9wX2VkZ2VfdGFibGVzKQ0KKyAgICAgICBpZiAoc3RtdC0+ZHJvcF9s YWJlbCB8fCBzdG10LT5kcm9wX3Byb3BlcnRpZXMgfHwgc3RtdC0+ZHJvcF92ZXJ0ZXhfdGFi bGVzIHx8IHN0bXQtPmRyb3BfZWRnZV90YWJsZXMpDQogICAgICAgIHsNCiAgICAgICAgICAg ICAgICBmb3JlYWNoX29pZChwcm9wb2lkLCBnZXRfZ3JhcGhfcHJvcGVydHlfaWRzKHBncmVs aWQpKQ0KICAgICAgICAgICAgICAgIHsNCmBgYA0KDQpgYGBzcWwNCnBvc3RncmVzQHp4bS1W TXdhcmUtVmlydHVhbC1QbGF0Zm9ybTp+L2NvZGUvcG9zdGdyZXMkIHBzcWwNCnBzcWwgKDE5 YmV0YTEpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KcG9zdGdyZXM9IyBDUkVBVEUgUFJP UEVSVFkgR1JBUEggZzENCiAgICBWRVJURVggVEFCTEVTICgNCiAgICAgICAgdjEgDQogICAg ICAgICAgICBMQUJFTCB2bDEgUFJPUEVSVElFUyAoYSwgYiwgYykNCiAgICAgICAgICAgIExB QkVMIHZsMiBQUk9QRVJUSUVTIChhKSBMQUJFTCB2bDMgUFJPUEVSVElFUyAoYSxiKQ0KICAg ICk7DQpDUkVBVEUgUFJPUEVSVFkgR1JBUEgNCnBvc3RncmVzPSMgQUxURVIgUFJPUEVSVFkg R1JBUEggZzEgQUxURVIgVkVSVEVYIFRBQkxFIHYxIERST1AgTEFCRUwgdmwxOw0KQUxURVIg UFJPUEVSVFkgR1JBUEgNCnBvc3RncmVzPSMgU0VMRUNUIG9pZCwgcGdwbmFtZSBGUk9NIHBn X3Byb3BncmFwaF9wcm9wZXJ0eSBXSEVSRSBwZ3BwZ2lkID0gJ2cxJzo6cmVnY2xhc3MgT1JE RVIgQlkgcGdwbmFtZTsNCiAgb2lkICAgfCBwZ3BuYW1lIA0KLS0tLS0tLS0rLS0tLS0tLS0t DQogMTExOTcxIHwgYQ0KIDExMTk3MyB8IGINCiAxMTE5NzUgfCBjDQooMyByb3dzKQ0KYGBg DQoNCkFmdGVyIGRyb3BwaW5nIHZsMSwgYiBhbmQgYyBhcmUgc3RpbGwgdGhlcmUgZXZlbiB0 aG91Z2ggbm8gbGFiZWwNCnJlZmVyZW5jZXMgdGhlbSBhbnltb3JlLiBOb3Qgc3VyZSBpZiB0 aGlzIGlzIHdvcnRoIGZpeGluZyAtLSB0aG91Z2h0cz8NCg0KLS0NCnJlZ2FyZHMsDQpNYW4g WmVuZw==