MIME-Version: 1.0
References: <40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv> <CAOVWO5p7PieGTm3GJC8NAYgSEQLoBdZw9Se4u=EbPrr1mW7d5Q@mail.gmail.com>
 <CAOVWO5rWkGXx37tpsAuTwrY5muPePHG44ke0xwYcakWVfhkPaw@mail.gmail.com>
 <CAOVWO5qchazoL8H+-d4eZ_zm8jFUH4YF3WvWnXqcDEh8i7hbhw@mail.gmail.com>
 <CAOVWO5qF2_FV7M=USdSgjjPO124YMpw7TY+M4+mnkNPOA2Bstg@mail.gmail.com>
 <CA+FpmFe7pgJRi16zP8Liz5vuUkVdTnPy30Zr=mXzZA3shKgvCw@mail.gmail.com> <CAOVWO5rfJGpxRDn496gAHmAxW7L_72==KkOcz0q16YOvqm4-=g@mail.gmail.com>
In-Reply-To: <CAOVWO5rfJGpxRDn496gAHmAxW7L_72==KkOcz0q16YOvqm4-=g@mail.gmail.com>
From: surya poondla <suryapoondla4@gmail.com>
Date: Mon, 2 Mar 2026 14:45:32 -0800
Message-ID: <CAOVWO5p2U8rMvh3pJ4WaNN7ES4SbiEKXLV_0pZ-UdYp0kACa7g@mail.gmail.com>
Subject: Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY
To: Rafia Sabih <rafia.pghackers@gmail.com>
Cc: Giuliano Gagliardi <gogi@gogi.tv>, pgsql-bugs@lists.postgresql.org
Content-Type: multipart/mixed; boundary="000000000000d49400064c1258d5"
Archived-At: <https://www.postgresql.org/message-id/CAOVWO5p2U8rMvh3pJ4WaNN7ES4SbiEKXLV_0pZ-UdYp0kACa7g%40mail.gmail.com>
Precedence: bulk

--000000000000d49400064c1258d5
Content-Type: multipart/alternative; boundary="000000000000d493fe064c1258d3"

--000000000000d493fe064c1258d3
Content-Type: text/plain; charset="UTF-8"

Hi All,

Thank you Rafia for the suggestions.
I split both the bugs in 2 different commits, attaching the patches here.

For bug1, I added the test case for NULL values too.

For bug 2, I only changed matview.c and added no test case as the timings
are not constant.

I ran the regression tests for both the patches and all tests succeeded in
both cases.

Regards,
Surya Poondla

>

--000000000000d493fe064c1258d3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi All,<br><br>Thank you Rafia for the suggestions.<b=
r>I split both the bugs in 2 different commits, attaching the patches here.=
<br><br>For bug1, I added the test case for NULL values too.<br><br>For bug=
 2, I only changed matview.c and added no test case=C2=A0as the timings are=
 not constant. <br><br>I ran the regression tests for both the patches and =
all tests succeeded in both cases.<br><br>Regards,<br>Surya Poondla</div><d=
iv class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">
</blockquote></div></div>

--000000000000d493fe064c1258d3--
--000000000000d49400064c1258d5
Content-Type: application/octet-stream; 
	name="0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch"
Content-Disposition: attachment; 
	filename="0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mm9rnwan0>
X-Attachment-Id: f_mm9rnwan0

RnJvbSBhNzRiZjcyNjFkODJmODRiMjczOTYyMjFlNjBjZWM0NDAwNDVkYWQ1IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBzcG9vbmRsYSA8c19wb29uZGxhQGFwcGxlLmNvbT4KRGF0ZTog
TW9uLCAyIE1hciAyMDI2IDExOjIyOjExIC0wODAwClN1YmplY3Q6IFtQQVRDSCB2M10gRml4IFJF
RlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVOVExZIHRvIGRldGVjdAogZHVwbGljYXRl
IHJvd3Mgd2l0aCBOVUxMcwoKUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyBDT05DVVJSRU5UTFkg
ZG9lc24ndCB0aHJvdyBleHBlY3RlZCBlcnJvciBhcyBSRUZSRVNIIE1BVEVSSUFMSVpFRCBWSUVX
Cklzc3VlOgpSRUZSRVNIIE1BVEVSSUFMSVpFRCBWSUVXIENPTkNVUlJFTlRMWSB3YXMgaW5jb3Jy
ZWN0bHkgc2tpcHBpbmcgZHVwbGljYXRlCmRldGVjdGlvbiBmb3Igcm93cyBjb250YWluaW5nIGFu
eSBOVUxMIHZhbHVlcy4gVGhpcyB3b3VsZCBjYXVzZSB0aGUgcmVmcmVzaAp0byBzaWxlbnRseSBz
dWNjZWVkIHdoaWxlIGxlYXZpbmcgdGhlIG1hdGVyaWFsaXplZCB2aWV3IHdpdGggc3RhbGUgZGF0
YSwKcmF0aGVyIHRoYW4gcHJvcGVybHkgcmVwb3J0aW5nIGR1cGxpY2F0ZSByb3cgZXJyb3JzLgoK
VGhlIGJ1ZyBvY2N1cnJlZCBiZWNhdXNlIHRoZSBkdXBsaWNhdGUgY2hlY2sgdXNlZCAiV0hFUkUg
bmV3ZGF0YS4qIElTIE5PVCBOVUxMIgp3aGljaCByZXR1cm5zIGZhbHNlIGlmIGFueSBjb2x1bW4g
Y29udGFpbnMgTlVMTC4gV2hlbiBkdXBsaWNhdGVzIGV4aXN0ZWQgaW4Kcm93cyB3aXRoIE5VTExz
IChlLmcuLCB0d28gcm93cyBvZiAoJ3Rlc3QnLCBOVUxMKSksIHRoZSBjaGVjayB3YXMgc2tpcHBl
ZAplbnRpcmVseS4gVGhlIHN1YnNlcXVlbnQgRlVMTCBPVVRFUiBKT0lOIHdvdWxkIHRoZW4gbWF0
Y2ggYm90aCBkdXBsaWNhdGUgcm93cwp0byB0aGUgc2FtZSBvbGQgcm93LCBwcm9kdWNpbmcgYW4g
ZW1wdHkgZGlmZiwgY2F1c2luZyBubyB1cGRhdGVzIHRvIGJlIGFwcGxpZWQuCgpGaXg6ClRoZSBm
aXggcmVtb3ZlcyB0aGUgIklTIE5PVCBOVUxMIiBwcmVjb25kaXRpb25zIGZyb20gdGhlIGR1cGxp
Y2F0ZSBkZXRlY3Rpb24KcXVlcnkuIFRoZSBxdWVyeSBub3cgY29ycmVjdGx5IGNoZWNrcyBhbGwg
cm93cyB1c2luZyB0aGUgcmVjb3JkIGVxdWFsaXR5Cm9wZXJhdG9yICgqPSksIHdoaWNoIHRyZWF0
cyBOVUxMIGFzIGVxdWFsIHRvIE5VTEwuIFRoaXMgbWF0Y2hlcyB0aGUgc2FtZQplcXVhbGl0eSBz
ZW1hbnRpY3MgdXNlZCBieSB0aGUgRlVMTCBPVVRFUiBKT0lOIGluIHRoZSBkaWZmIHF1ZXJ5LCBl
bnN1cmluZwpjb25zaXN0ZW50IGR1cGxpY2F0ZSBkZXRlY3Rpb24uCgpBZGRlZCBhIHJlZ3Jlc3Np
b24gdGVzdCBjb3ZlcmluZyB0aGUgY2FzZSBvZiBkdXBsaWNhdGUgcm93cyB0aGF0IGNvbnRhaW4K
TlVMTCB2YWx1ZXMuCgpOb3RlOgpUaGUgbm9uLWNvbmN1cnJlbnQgUkVGUkVTSCB3YXMgdW5hZmZl
Y3RlZCBzaW5jZSBpdCByZWJ1aWxkcyBpbmRleGVzIGZyb20Kc2NyYXRjaCwgd2hpY2ggcHJvcGVy
bHkgZGV0ZWN0cyBkdXBsaWNhdGVzIGR1cmluZyBpbmRleCBjcmVhdGlvbi4KLS0tCiBzcmMvYmFj
a2VuZC9jb21tYW5kcy9tYXR2aWV3LmMgICAgICAgIHwgMjAgKysrKysrKysrKystLS0tLS0tLS0K
IHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWF0dmlldy5vdXQgfCAxNiArKysrKysrKysrKysr
KystCiBzcmMvdGVzdC9yZWdyZXNzL3NxbC9tYXR2aWV3LnNxbCAgICAgIHwgMTAgKysrKysrKysr
KwogMyBmaWxlcyBjaGFuZ2VkLCAzNiBpbnNlcnRpb25zKCspLCAxMCBkZWxldGlvbnMoLSkKCmRp
ZmYgLS1naXQgYS9zcmMvYmFja2VuZC9jb21tYW5kcy9tYXR2aWV3LmMgYi9zcmMvYmFja2VuZC9j
b21tYW5kcy9tYXR2aWV3LmMKaW5kZXggODFhNTVhMzNlZjIuLmU5MGIxMDk3MmVmIDEwMDY0NAot
LS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy9tYXR2aWV3LmMKKysrIGIvc3JjL2JhY2tlbmQvY29t
bWFuZHMvbWF0dmlldy5jCkBAIC02MzUsMTEgKzYzNSwxMyBAQCByZWZyZXNoX2J5X21hdGNoX21l
cmdlKE9pZCBtYXR2aWV3T2lkLCBPaWQgdGVtcE9pZCwgT2lkIHJlbG93bmVyLAogCQllbG9nKEVS
Uk9SLCAiU1BJX2V4ZWMgZmFpbGVkOiAlcyIsIHF1ZXJ5YnVmLmRhdGEpOwogCiAJLyoKLQkgKiBX
ZSBuZWVkIHRvIGVuc3VyZSB0aGF0IHRoZXJlIGFyZSBub3QgZHVwbGljYXRlIHJvd3Mgd2l0aG91
dCBOVUxMcyBpbgotCSAqIHRoZSBuZXcgZGF0YSBzZXQgYmVmb3JlIHdlIGNhbiBjb3VudCBvbiB0
aGUgImRpZmYiIHJlc3VsdHMuICBDaGVjayBmb3IKLQkgKiB0aGF0IGluIGEgd2F5IHRoYXQgYWxs
b3dzIHNob3dpbmcgdGhlIGZpcnN0IGR1cGxpY2F0ZWQgcm93IGZvdW5kLiAgRXZlbgotCSAqIGFm
dGVyIHdlIHBhc3MgdGhpcyB0ZXN0LCBhIHVuaXF1ZSBpbmRleCBvbiB0aGUgbWF0ZXJpYWxpemVk
IHZpZXcgbWF5Ci0JICogZmluZCBhIGR1cGxpY2F0ZSBrZXkgcHJvYmxlbS4KKwkgKiBXZSBuZWVk
IHRvIGVuc3VyZSB0aGF0IHRoZXJlIGFyZSBub3QgZHVwbGljYXRlIHJvd3MgaW4gdGhlIG5ldyBk
YXRhIHNldAorCSAqIGJlZm9yZSB3ZSBjYW4gY291bnQgb24gdGhlICJkaWZmIiByZXN1bHRzLiAg
Q2hlY2sgZm9yIHRoYXQgaW4gYSB3YXkKKwkgKiB0aGF0IGFsbG93cyBzaG93aW5nIHRoZSBmaXJz
dCBkdXBsaWNhdGVkIHJvdyBmb3VuZC4gIFdlIGNoZWNrIGZvcgorCSAqIGR1cGxpY2F0ZXMgdXNp
bmcgdGhlIHJlY29yZCBlcXVhbGl0eSBvcGVyYXRvciAoKj0pLCB3aGljaCB0cmVhdHMgTlVMTHMK
KwkgKiBhcyBlcXVhbCB0byBlYWNoIG90aGVyIC0tLSB0aGUgc2FtZSBzZW1hbnRpY3MgdXNlZCBi
eSB0aGUgRlVMTCBPVVRFUgorCSAqIEpPSU4gaW4gdGhlIGRpZmYgcXVlcnkgYmVsb3cuICBFdmVu
IGFmdGVyIHdlIHBhc3MgdGhpcyB0ZXN0LCBhIHVuaXF1ZQorCSAqIGluZGV4IG9uIHRoZSBtYXRl
cmlhbGl6ZWQgdmlldyBtYXkgZmluZCBhIGR1cGxpY2F0ZSBrZXkgcHJvYmxlbS4KIAkgKgogCSAq
IE5vdGU6IGhlcmUgYW5kIGJlbG93LCB3ZSB1c2UgInRhYmxlbmFtZS4qOjp0YWJsZXJvd3R5cGUi
IGFzIGEgaGFjayB0bwogCSAqIGtlZXAgIi4qIiBmcm9tIGJlaW5nIGV4cGFuZGVkIGludG8gbXVs
dGlwbGUgY29sdW1ucyBpbiBhIFNFTEVDVCBsaXN0LgpAQCAtNjQ4LDkgKzY1MCw5IEBAIHJlZnJl
c2hfYnlfbWF0Y2hfbWVyZ2UoT2lkIG1hdHZpZXdPaWQsIE9pZCB0ZW1wT2lkLCBPaWQgcmVsb3du
ZXIsCiAJcmVzZXRTdHJpbmdJbmZvKCZxdWVyeWJ1Zik7CiAJYXBwZW5kU3RyaW5nSW5mbygmcXVl
cnlidWYsCiAJCQkJCSAiU0VMRUNUIG5ld2RhdGEuKjo6JXMgRlJPTSAlcyBuZXdkYXRhICIKLQkJ
CQkJICJXSEVSRSBuZXdkYXRhLiogSVMgTk9UIE5VTEwgQU5EIEVYSVNUUyAiCi0JCQkJCSAiKFNF
TEVDVCAxIEZST00gJXMgbmV3ZGF0YTIgV0hFUkUgbmV3ZGF0YTIuKiBJUyBOT1QgTlVMTCAiCi0J
CQkJCSAiQU5EIG5ld2RhdGEyLiogT1BFUkFUT1IocGdfY2F0YWxvZy4qPSkgbmV3ZGF0YS4qICIK
KwkJCQkJICJXSEVSRSBFWElTVFMgIgorCQkJCQkgIihTRUxFQ1QgMSBGUk9NICVzIG5ld2RhdGEy
ICIKKwkJCQkJICJXSEVSRSBuZXdkYXRhMi4qIE9QRVJBVE9SKHBnX2NhdGFsb2cuKj0pIG5ld2Rh
dGEuKiAiCiAJCQkJCSAiQU5EIG5ld2RhdGEyLmN0aWQgT1BFUkFUT1IocGdfY2F0YWxvZy48Pikg
IgogCQkJCQkgIm5ld2RhdGEuY3RpZCkiLAogCQkJCQkgdGVtcG5hbWUsIHRlbXBuYW1lLCB0ZW1w
bmFtZSk7CkBAIC02NjcsNyArNjY5LDcgQEAgcmVmcmVzaF9ieV9tYXRjaF9tZXJnZShPaWQgbWF0
dmlld09pZCwgT2lkIHRlbXBPaWQsIE9pZCByZWxvd25lciwKIAkJICovCiAJCWVyZXBvcnQoRVJS
T1IsCiAJCQkJKGVycmNvZGUoRVJSQ09ERV9DQVJESU5BTElUWV9WSU9MQVRJT04pLAotCQkJCSBl
cnJtc2coIm5ldyBkYXRhIGZvciBtYXRlcmlhbGl6ZWQgdmlldyBcIiVzXCIgY29udGFpbnMgZHVw
bGljYXRlIHJvd3Mgd2l0aG91dCBhbnkgbnVsbCBjb2x1bW5zIiwKKwkJCQkgZXJybXNnKCJuZXcg
ZGF0YSBmb3IgbWF0ZXJpYWxpemVkIHZpZXcgXCIlc1wiIGNvbnRhaW5zIGR1cGxpY2F0ZSByb3dz
IiwKIAkJCQkJCVJlbGF0aW9uR2V0UmVsYXRpb25OYW1lKG1hdHZpZXdSZWwpKSwKIAkJCQkgZXJy
ZGV0YWlsKCJSb3c6ICVzIiwKIAkJCQkJCSAgIFNQSV9nZXR2YWx1ZShTUElfdHVwdGFibGUtPnZh
bHNbMF0sIFNQSV90dXB0YWJsZS0+dHVwZGVzYywgMSkpKSk7CmRpZmYgLS1naXQgYS9zcmMvdGVz
dC9yZWdyZXNzL2V4cGVjdGVkL21hdHZpZXcub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl
ZC9tYXR2aWV3Lm91dAppbmRleCAwMzU1NzIwZGZjNi4uM2Y2NmFkYTFiNmIgMTAwNjQ0Ci0tLSBh
L3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvbWF0dmlldy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVn
cmVzcy9leHBlY3RlZC9tYXR2aWV3Lm91dApAQCAtMzk2LDEwICszOTYsMjQgQEAgUkVGUkVTSCBN
QVRFUklBTElaRUQgVklFVyBtdnRlc3RfbXY7CiBFUlJPUjogIGNvdWxkIG5vdCBjcmVhdGUgdW5p
cXVlIGluZGV4ICJtdnRlc3RfbXZfYV9pZHgiCiBERVRBSUw6ICBLZXkgKGEpPSgxKSBpcyBkdXBs
aWNhdGVkLgogUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyBDT05DVVJSRU5UTFkgbXZ0ZXN0X212
OwotRVJST1I6ICBuZXcgZGF0YSBmb3IgbWF0ZXJpYWxpemVkIHZpZXcgIm12dGVzdF9tdiIgY29u
dGFpbnMgZHVwbGljYXRlIHJvd3Mgd2l0aG91dCBhbnkgbnVsbCBjb2x1bW5zCitFUlJPUjogIG5l
dyBkYXRhIGZvciBtYXRlcmlhbGl6ZWQgdmlldyAibXZ0ZXN0X212IiBjb250YWlucyBkdXBsaWNh
dGUgcm93cwogREVUQUlMOiAgUm93OiAoMSwxMCkKIERST1AgVEFCTEUgbXZ0ZXN0X2ZvbyBDQVND
QURFOwogTk9USUNFOiAgZHJvcCBjYXNjYWRlcyB0byBtYXRlcmlhbGl6ZWQgdmlldyBtdnRlc3Rf
bXYKKy0tIHRlc3QgdGhhdCBkdXBsaWNhdGUgcm93cyBjb250YWluaW5nIE5VTExzIGFyZSBhbHNv
IGRldGVjdGVkIChidWcgZml4KQorQ1JFQVRFIFRBQkxFIG12dGVzdF9mb28oYSB0ZXh0LCBiIHRl
eHQpOworSU5TRVJUIElOVE8gbXZ0ZXN0X2ZvbyBWQUxVRVMoJ3Rlc3QnLCBOVUxMKTsKK0NSRUFU
RSBNQVRFUklBTElaRUQgVklFVyBtdnRlc3RfbXYgQVMgU0VMRUNUICogRlJPTSBtdnRlc3RfZm9v
OworQ1JFQVRFIFVOSVFVRSBJTkRFWCBPTiBtdnRlc3RfbXYoYSk7CitJTlNFUlQgSU5UTyBtdnRl
c3RfZm9vIFZBTFVFUygndGVzdCcsIE5VTEwpOworUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyBt
dnRlc3RfbXY7CitFUlJPUjogIGNvdWxkIG5vdCBjcmVhdGUgdW5pcXVlIGluZGV4ICJtdnRlc3Rf
bXZfYV9pZHgiCitERVRBSUw6ICBLZXkgKGEpPSh0ZXN0KSBpcyBkdXBsaWNhdGVkLgorUkVGUkVT
SCBNQVRFUklBTElaRUQgVklFVyBDT05DVVJSRU5UTFkgbXZ0ZXN0X212OworRVJST1I6ICBuZXcg
ZGF0YSBmb3IgbWF0ZXJpYWxpemVkIHZpZXcgIm12dGVzdF9tdiIgY29udGFpbnMgZHVwbGljYXRl
IHJvd3MKK0RFVEFJTDogIFJvdzogKHRlc3QsKQorRFJPUCBUQUJMRSBtdnRlc3RfZm9vIENBU0NB
REU7CitOT1RJQ0U6ICBkcm9wIGNhc2NhZGVzIHRvIG1hdGVyaWFsaXplZCB2aWV3IG12dGVzdF9t
dgogLS0gbWFrZSBzdXJlIHRoYXQgYWxsIGNvbHVtbnMgY292ZXJlZCBieSB1bmlxdWUgaW5kZXhl
cyB3b3JrcwogQ1JFQVRFIFRBQkxFIG12dGVzdF9mb28oYSwgYiwgYykgQVMgVkFMVUVTKDEsIDIs
IDMpOwogQ1JFQVRFIE1BVEVSSUFMSVpFRCBWSUVXIG12dGVzdF9tdiBBUyBTRUxFQ1QgKiBGUk9N
IG12dGVzdF9mb287CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9tYXR2aWV3LnNx
bCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL21hdHZpZXcuc3FsCmluZGV4IDkzNDQyNmI5YWU4Li5k
MTRhNWI5NTM4NCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvbWF0dmlldy5zcWwK
KysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvbWF0dmlldy5zcWwKQEAgLTEzNSw2ICsxMzUsMTYg
QEAgUkVGUkVTSCBNQVRFUklBTElaRUQgVklFVyBtdnRlc3RfbXY7CiBSRUZSRVNIIE1BVEVSSUFM
SVpFRCBWSUVXIENPTkNVUlJFTlRMWSBtdnRlc3RfbXY7CiBEUk9QIFRBQkxFIG12dGVzdF9mb28g
Q0FTQ0FERTsKIAorLS0gdGVzdCB0aGF0IGR1cGxpY2F0ZSByb3dzIGNvbnRhaW5pbmcgTlVMTHMg
YXJlIGFsc28gZGV0ZWN0ZWQgKGJ1ZyBmaXgpCitDUkVBVEUgVEFCTEUgbXZ0ZXN0X2ZvbyhhIHRl
eHQsIGIgdGV4dCk7CitJTlNFUlQgSU5UTyBtdnRlc3RfZm9vIFZBTFVFUygndGVzdCcsIE5VTEwp
OworQ1JFQVRFIE1BVEVSSUFMSVpFRCBWSUVXIG12dGVzdF9tdiBBUyBTRUxFQ1QgKiBGUk9NIG12
dGVzdF9mb287CitDUkVBVEUgVU5JUVVFIElOREVYIE9OIG12dGVzdF9tdihhKTsKK0lOU0VSVCBJ
TlRPIG12dGVzdF9mb28gVkFMVUVTKCd0ZXN0JywgTlVMTCk7CitSRUZSRVNIIE1BVEVSSUFMSVpF
RCBWSUVXIG12dGVzdF9tdjsKK1JFRlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVOVExZ
IG12dGVzdF9tdjsKK0RST1AgVEFCTEUgbXZ0ZXN0X2ZvbyBDQVNDQURFOworCiAtLSBtYWtlIHN1
cmUgdGhhdCBhbGwgY29sdW1ucyBjb3ZlcmVkIGJ5IHVuaXF1ZSBpbmRleGVzIHdvcmtzCiBDUkVB
VEUgVEFCTEUgbXZ0ZXN0X2ZvbyhhLCBiLCBjKSBBUyBWQUxVRVMoMSwgMiwgMyk7CiBDUkVBVEUg
TUFURVJJQUxJWkVEIFZJRVcgbXZ0ZXN0X212IEFTIFNFTEVDVCAqIEZST00gbXZ0ZXN0X2ZvbzsK
LS0gCjIuMzkuNSAoQXBwbGUgR2l0LTE1NCkKCg==
--000000000000d49400064c1258d5
Content-Type: application/octet-stream; 
	name="0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-performance_bug2.patch"
Content-Disposition: attachment; 
	filename="0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-performance_bug2.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mm9rogkr1>
X-Attachment-Id: f_mm9rogkr1

RnJvbSA5ODJkNzIxMDEzYWJmMDRiNWViYTM2Y2UxYWJhYjM1MDg5NDg4M2IyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBzcG9vbmRsYSA8c19wb29uZGxhQGFwcGxlLmNvbT4KRGF0ZTog
TW9uLCAyIE1hciAyMDI2IDExOjIzOjE3IC0wODAwClN1YmplY3Q6IFtQQVRDSCB2M10gRml4IFJF
RlJFU0ggTUFURVJJQUxJWkVEIFZJRVcgQ09OQ1VSUkVOVExZIHBlcmZvcm1hbmNlCiB3aXRoIG51
bGxhYmxlIGluZGV4ZWQgY29sdW1ucwoKSXNzdWU6CldoZW4gYSBtYXRlcmlhbGl6ZWQgdmlldyBo
YXMgYSB1bmlxdWUgaW5kZXggb24gYSBudWxsYWJsZSBjb2x1bW4sIFJFRlJFU0gKTUFURVJJQUxJ
WkVEIFZJRVcgQ09OQ1VSUkVOVExZIGluY2x1ZGVkIHRoYXQgY29sdW1uIGluIHRoZSBGVUxMIE9V
VEVSIEpPSU4KY29uZGl0aW9uIHVzZWQgdG8gZGV0ZWN0IGNoYW5nZXMuICBUaGlzIGNhdXNlZCBz
ZXZlcmUgcGVyZm9ybWFuY2UgZGVncmFkYXRpb24KYmVjYXVzZSBzdGFuZGFyZCBlcXVhbGl0eSAo
Y29sID0gY29sKSBldmFsdWF0ZXMgdG8gTlVMTCB3aGVuIGVpdGhlciBzaWRlIGlzCk5VTEwsIGNh
dXNpbmcgdW5jaGFuZ2VkIHJvd3MgdG8gYXBwZWFyIGFzIGJvdGggZGVsZXRlZCBhbmQgcmUtaW5z
ZXJ0ZWQuCgpFeGFtcGxlOgpBIG1hdGVyaWFsaXplZCB2aWV3IHdpdGggMU0gcm93cyB3aGVyZSBh
IG51bGxhYmxlIGluZGV4ZWQgY29sdW1uCmNvbnRhaW5zIGFsbCBOVUxMcy4gV2hlbiBkYXRhIGlz
IHVuY2hhbmdlZCwgdGhlIHJlZnJlc2ggc2hvdWxkIHByb2R1Y2UgYW4KZW1wdHkgZGlmZiAoMCBy
b3dzKS4gSG93ZXZlciwgYmVjYXVzZSBOVUxMID0gTlVMTCBldmFsdWF0ZXMgdG8gTlVMTCAobm90
IFRSVUUpLAp0aGUgam9pbiBmYWlscyB0byBtYXRjaCBhbnkgcm93cy4gVGhlIGRpZmYgaW5jb3Jy
ZWN0bHkgc2hvd3MgYWxsIDFNIHJvd3MgYXMKZGVsZXRlZCBhbmQgYWxsIDFNIHJvd3MgYXMgbmV3
bHkgaW5zZXJ0ZWQsIHNvIDJNIGNoYW5nZXMgaW4gdG90YWwsIGNhdXNpbmcgdW5uZWNlc3NhcnkK
dXNlIG9mIHJlc291cmNlcyB3aGljaCBkcmFzdGljYWxseSBpbmNyZWFzZWQgdGhlIHRpbWUgZm9y
ICJyZWZyZXNoIG1hdGVyaWFsaXplZCB2aWV3IGNvbmN1cnJlbnRseSIgb3BlcmF0aW9uLgoKRml4
OgpTa2lwIG51bGxhYmxlIGNvbHVtbnMgd2hlbiBidWlsZGluZyB0aGUgRlVMTCBPVVRFUiBKT0lO
IGVxdWFsaXR5IGNvbmRpdGlvbnMuCk9ubHkgaW5jbHVkZSBjb2x1bW5zIHdpdGggTk9UIE5VTEwg
Y29uc3RyYWludHMgZnJvbSB1bmlxdWUgaW5kZXhlcyBpbiB0aGUgam9pbgpwcmVkaWNhdGUuClRo
aXMgaXMgc2VtYW50aWNhbGx5IGNvcnJlY3QgYmVjYXVzZSBudWxsYWJsZSBjb2x1bW5zIGluIHVu
aXF1ZQppbmRleGVzIGRvIG5vdCBndWFyYW50ZWUgcm93IHVuaXF1ZW5lc3MgZm9yIE5VTEwgdmFs
dWVzIChtdWx0aXBsZSBOVUxMcyBhcmUgYWxsb3dlZCkuClRoZSByZWNvcmQgZXF1YWxpdHkgb3Bl
cmF0b3IgKCo9KSwgd2hpY2ggaXMgYWx3YXlzIGFwcGVuZGVkIHRvIHRoZQpqb2luIHByZWRpY2F0
ZSwgYWxyZWFkeSBoYW5kbGVzIGFsbCBjb2x1bW5zIGluY2x1ZGluZyBudWxsYWJsZSBvbmVzIChp
LmUgdHJlYXRpbmcgTlVMTCBhcyBlcXVhbCB0byBOVUxMLikKClRoZSBmaXggYWRkcyBhIG5ldyB2
YXJpYWJsZSAnYWRkZWRBbnlRdWFscycgdG8gdHJhY2sgd2hldGhlciBhbnkgY29sdW1uIGNvbmRp
dGlvbnMKd2VyZSBhY3R1YWxseSBhZGRlZCB0byB0aGUgcXVlcnksIHNlcGFyYXRlIGZyb20gJ2Zv
dW5kVW5pcXVlSW5kZXgnIHdoaWNoIHRyYWNrcwp3aGV0aGVyIGEgdXNhYmxlIHVuaXF1ZSBpbmRl
eCBleGlzdHMgKGZvciB2YWxpZGF0aW9uKS4KVGhpcyBlbnN1cmVzIGNvcnJlY3QgU1FMIHN5bnRh
eCB3aGVuIGFsbCBjb2x1bW5zIGluIGFuIGluZGV4IGFyZSBudWxsYWJsZS4KLS0tCiBzcmMvYmFj
a2VuZC9jb21tYW5kcy9tYXR2aWV3LmMgfCAzMCArKysrKysrKysrKysrKysrKysrKysrKysrKyst
LS0KIDEgZmlsZSBjaGFuZ2VkLCAyNyBpbnNlcnRpb25zKCspLCAzIGRlbGV0aW9ucygtKQoKZGlm
ZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL21hdHZpZXcuYyBiL3NyYy9iYWNrZW5kL2Nv
bW1hbmRzL21hdHZpZXcuYwppbmRleCA4MWE1NWEzM2VmMi4uMjM2YzIzMzkxNGMgMTAwNjQ0Ci0t
LSBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL21hdHZpZXcuYworKysgYi9zcmMvYmFja2VuZC9jb21t
YW5kcy9tYXR2aWV3LmMKQEAgLTYwMiw2ICs2MDIsNyBAQCByZWZyZXNoX2J5X21hdGNoX21lcmdl
KE9pZCBtYXR2aWV3T2lkLCBPaWQgdGVtcE9pZCwgT2lkIHJlbG93bmVyLAogCWNoYXIJICAgKm5z
cDsKIAlUdXBsZURlc2MJdHVwZGVzYzsKIAlib29sCQlmb3VuZFVuaXF1ZUluZGV4OworCWJvb2wJ
CWFkZGVkQW55UXVhbHM7CiAJTGlzdAkgICAqaW5kZXhvaWRsaXN0OwogCUxpc3RDZWxsICAgKmlu
ZGV4b2lkc2NhbjsKIAlpbnQxNgkJcmVsbmF0dHM7CkBAIC03MTUsNiArNzE2LDcgQEAgcmVmcmVz
aF9ieV9tYXRjaF9tZXJnZShPaWQgbWF0dmlld09pZCwgT2lkIHRlbXBPaWQsIE9pZCByZWxvd25l
ciwKIAl0dXBkZXNjID0gbWF0dmlld1JlbC0+cmRfYXR0OwogCW9wVXNlZEZvclF1YWwgPSBwYWxs
b2MwX2FycmF5KE9pZCwgcmVsbmF0dHMpOwogCWZvdW5kVW5pcXVlSW5kZXggPSBmYWxzZTsKKwlh
ZGRlZEFueVF1YWxzID0gZmFsc2U7CiAKIAlpbmRleG9pZGxpc3QgPSBSZWxhdGlvbkdldEluZGV4
TGlzdChtYXR2aWV3UmVsKTsKIApAQCAtNzMyLDYgKzczNCw4IEBAIHJlZnJlc2hfYnlfbWF0Y2hf
bWVyZ2UoT2lkIG1hdHZpZXdPaWQsIE9pZCB0ZW1wT2lkLCBPaWQgcmVsb3duZXIsCiAJCQlEYXR1
bQkJaW5kY2xhc3NEYXR1bTsKIAkJCWludAkJCWk7CiAKKwkJCWZvdW5kVW5pcXVlSW5kZXggPSB0
cnVlOworCiAJCQkvKiBNdXN0IGdldCBpbmRjbGFzcyB0aGUgaGFyZCB3YXkuICovCiAJCQlpbmRj
bGFzc0RhdHVtID0gU3lzQ2FjaGVHZXRBdHRyTm90TnVsbChJTkRFWFJFTElELAogCQkJCQkJCQkJ
CQkJICAgaW5kZXhSZWwtPnJkX2luZGV4dHVwbGUsCkBAIC03NTMsNiArNzU3LDE4IEBAIHJlZnJl
c2hfYnlfbWF0Y2hfbWVyZ2UoT2lkIG1hdHZpZXdPaWQsIE9pZCB0ZW1wT2lkLCBPaWQgcmVsb3du
ZXIsCiAJCQkJY29uc3QgY2hhciAqbGVmdG9wOwogCQkJCWNvbnN0IGNoYXIgKnJpZ2h0b3A7CiAK
KwkJCQkvKgorCQkJCSAqIFNraXAgbnVsbGFibGUgY29sdW1ucy4gIE51bGxhYmxlIGNvbHVtbnMg
aW4gdW5pcXVlIGluZGV4ZXMKKwkJCQkgKiBkb24ndCBwcm92aWRlIHJvdyB1bmlxdWVuZXNzIGZv
ciBOVUxMIHZhbHVlcyAobXVsdGlwbGUgTlVMTHMKKwkJCQkgKiBhcmUgYWxsb3dlZCksIHNvIHRo
ZXkgY2Fubm90IHJlbGlhYmx5IGlkZW50aWZ5IG1hdGNoaW5nIHJvd3MuCisJCQkJICogSW5jbHVk
aW5nIHRoZW0gaW4gdGhlIGpvaW4gY29uZGl0aW9uIGNhdXNlcyBOVUxMID0gTlVMTAorCQkJCSAq
IGNvbXBhcmlzb25zIHdoaWNoIGV2YWx1YXRlIHRvIE5VTEwsIG1ha2luZyB1bmNoYW5nZWQgcm93
cworCQkJCSAqIGFwcGVhciBkaWZmZXJlbnQuICBUaGUgcmVjb3JkIGVxdWFsaXR5IG9wZXJhdG9y
ICgqPSkgYXBwZW5kZWQKKwkJCQkgKiBiZWxvdyBoYW5kbGVzIGFsbCBjb2x1bW5zIGluY2x1ZGlu
ZyBudWxsYWJsZSBvbmVzLgorCQkJCSAqLworCQkJCWlmICghYXR0ci0+YXR0bm90bnVsbCkKKwkJ
CQkJY29udGludWU7CisKIAkJCQkvKgogCQkJCSAqIElkZW50aWZ5IHRoZSBlcXVhbGl0eSBvcGVy
YXRvciBhc3NvY2lhdGVkIHdpdGggdGhpcyBpbmRleAogCQkJCSAqIGNvbHVtbi4gIEZpcnN0IHdl
IG5lZWQgdG8gbG9vayB1cCB0aGUgY29sdW1uJ3Mgb3BjbGFzcy4KQEAgLTc4OCw3ICs4MDQsNyBA
QCByZWZyZXNoX2J5X21hdGNoX21lcmdlKE9pZCBtYXR2aWV3T2lkLCBPaWQgdGVtcE9pZCwgT2lk
IHJlbG93bmVyLAogCQkJCS8qCiAJCQkJICogQWN0dWFsbHkgYWRkIHRoZSBxdWFsLCBBTkRlZCB3
aXRoIGFueSBvdGhlcnMuCiAJCQkJICovCi0JCQkJaWYgKGZvdW5kVW5pcXVlSW5kZXgpCisJCQkJ
aWYgKGFkZGVkQW55UXVhbHMpCiAJCQkJCWFwcGVuZFN0cmluZ0luZm9TdHJpbmcoJnF1ZXJ5YnVm
LCAiIEFORCAiKTsKIAogCQkJCWxlZnRvcCA9IHF1b3RlX3F1YWxpZmllZF9pZGVudGlmaWVyKCJu
ZXdkYXRhIiwKQEAgLTgwMSw3ICs4MTcsNyBAQCByZWZyZXNoX2J5X21hdGNoX21lcmdlKE9pZCBt
YXR2aWV3T2lkLCBPaWQgdGVtcE9pZCwgT2lkIHJlbG93bmVyLAogCQkJCQkJCQkJCSBvcCwKIAkJ
CQkJCQkJCQkgcmlnaHRvcCwgYXR0cnR5cGUpOwogCi0JCQkJZm91bmRVbmlxdWVJbmRleCA9IHRy
dWU7CisJCQkJYWRkZWRBbnlRdWFscyA9IHRydWU7CiAJCQl9CiAJCX0KIApAQCAtODI2LDggKzg0
MiwxNiBAQCByZWZyZXNoX2J5X21hdGNoX21lcmdlKE9pZCBtYXR2aWV3T2lkLCBPaWQgdGVtcE9p
ZCwgT2lkIHJlbG93bmVyLAogCQkJCWVycm1zZygiY291bGQgbm90IGZpbmQgc3VpdGFibGUgdW5p
cXVlIGluZGV4IG9uIG1hdGVyaWFsaXplZCB2aWV3IFwiJXNcIiIsCiAJCQkJCSAgIFJlbGF0aW9u
R2V0UmVsYXRpb25OYW1lKG1hdHZpZXdSZWwpKSk7CiAKKwkvKgorCSAqIFRoZSByZWNvcmQgZXF1
YWxpdHkgb3BlcmF0b3IgKCo9KSBpcyBhbHdheXMgaW5jbHVkZWQgaW4gdGhlIGpvaW4KKwkgKiBw
cmVkaWNhdGUuICBJdCBoYW5kbGVzIGFsbCBjb2x1bW5zIGNvcnJlY3RseSBpbmNsdWRpbmcgbnVs
bGFibGUgb25lcworCSAqIHRoYXQgd2VyZSBza2lwcGVkIGFib3ZlLCBzaW5jZSAqPSAgdHJlYXRz
IE5VTEwgYXMgZXF1YWwgdG8gTlVMTC4KKwkgKi8KKwlpZiAoYWRkZWRBbnlRdWFscykKKwkJYXBw
ZW5kU3RyaW5nSW5mb1N0cmluZygmcXVlcnlidWYsICIgQU5EICIpOworCiAJYXBwZW5kU3RyaW5n
SW5mb1N0cmluZygmcXVlcnlidWYsCi0JCQkJCQkgICAiIEFORCBuZXdkYXRhLiogT1BFUkFUT1Io
cGdfY2F0YWxvZy4qPSkgbXYuKikgIgorCQkJCQkJICAgIm5ld2RhdGEuKiBPUEVSQVRPUihwZ19j
YXRhbG9nLio9KSBtdi4qKSAiCiAJCQkJCQkgICAiV0hFUkUgbmV3ZGF0YS4qIElTIE5VTEwgT1Ig
bXYuKiBJUyBOVUxMICIKIAkJCQkJCSAgICJPUkRFUiBCWSB0aWQiKTsKIAotLSAKMi4zOS41IChB
cHBsZSBHaXQtMTU0KQoK
--000000000000d49400064c1258d5--