MIME-Version: 1.0
References: <20211008.165055.1621145185927268721.horikyota.ntt@gmail.com>
 <CAD21AoD00wV4gt-53ze+ZB8n4bqJrdH8J_UnDHddy8S2A+a25g@mail.gmail.com>
 <CAA4eK1L_e4r4=10TTzoOiWGQ6hH4vxWAwD=0aofz04czCTV0kQ@mail.gmail.com>
 <20220523.133323.444599955292141474.horikyota.ntt@gmail.com>
 <CAA4eK1JoKV2qmp916gFk=9SX=Qo21+sN4n-yjbB2b0Q1xxOKJw@mail.gmail.com>
 <CAD21AoAn9T6mS8sMF5=tFV66Wru92s933ihRVunLPEU_+0=Xiw@mail.gmail.com>
 <CAA4eK1Lgfj2ww4V_zMxTmduB0BQpEsS-j7RT8BV-cy7Qyp1E3A@mail.gmail.com>
 <CAD21AoDNJgYkrO1PQ=k6G9MfvRjhawMN-aZVT2spMr_ymmOhCQ@mail.gmail.com>
 <CAD21AoC4x3uOw5rUcSYZkWob5s5ottGt_RPLxCEpHimFRDjrEg@mail.gmail.com>
 <CAA4eK1L_Br0wNHwY1PrnusX1H2bvWR+iUnNC=1anKqhPBtnoMg@mail.gmail.com>
 <CAD21AoBeMVfY6dvg5J8XmSHGbc3+yTA8k_GVRzwZR24zc4TfSw@mail.gmail.com>
 <CAA4eK1Jg+u=ouXbC5EVLVnQ4sUhrR1P+p0LQSjPFmMP4jNYmuw@mail.gmail.com>
 <CAD21AoCEF6FAvRRP6LKzq2-2oVvpdQbmZDwzRAdseA9AA2mE-Q@mail.gmail.com>
 <OSZPR01MB63106E9CE179D80F46CB3154FD8B9@OSZPR01MB6310.jpnprd01.prod.outlook.com>
 <CAD21AoAUx28e-1YQDA6Uhda+=jkidAy+HY8Zv5SYjtXpRcBiVg@mail.gmail.com>
 <CAA4eK1LmyPryHUP3kaWRBbz88aCs5J_8-vL2wqwi5wnSwa24tw@mail.gmail.com>
 <CAD21AoC1H8tDo=h-xsm5Und-c4FQbNCAOuRoBaMhsxNsJrM8vA@mail.gmail.com>
 <CAA4eK1JfcR96cxqb+NYmDueirpvLytfvP-UZPz-E6-U6Lv-+tw@mail.gmail.com>
 <CAD21AoCjfmuCRUpsn+nuqRuWW3gQCBdTKuYGYvYiwLVtpTQYSg@mail.gmail.com>
 <CAA4eK1LXpPnLEdTttCmMbw3bSnrn=k_58ZUDvx3zbAHLjgod2A@mail.gmail.com>
 <CAD21AoBKb_XMdOO0vCAHKieWYqHmJnEN0bGmV5j7PvOGOEkmrQ@mail.gmail.com>
 <CAA4eK1LpxNwGKntRJSND8H-DmN8XuZYoaooQmaX4+g-ePqg2=Q@mail.gmail.com>
 <CAD21AoCzuV5yhOGw8=nVkymkE0KaHkxMMy5R-HsfBQw9=h0asA@mail.gmail.com>
 <CAA4eK1LH54gTKnxhBJRy9GHjoPxp7ggA+B9Cy7VLtXToCVukhw@mail.gmail.com>
 <CAD21AoC8NLGJ-Q+u60cGPSnxXqexEFPLo-5-offsgCE_ikVxRw@mail.gmail.com>
 <CAA4eK1+U1b7P2mMTZHGE0GaT4vYhGsShQx_6070a6xgwj9JQAQ@mail.gmail.com>
 <CAD21AoC_oEy3EvgbJ=asz20Z3ROWtRM01f-F8+F_5VjhCvJX6g@mail.gmail.com>
 <CAD21AoAxuMzBAkOYD8ggxwNbobRx=sDPmy_JnYMkKP2sesu6+w@mail.gmail.com>
 <OSZPR01MB631075F474BAFBDBD6F2DB6EFD959@OSZPR01MB6310.jpnprd01.prod.outlook.com>
 <CAD21AoDGTaT4rdJHKc2hypYeDjdUdmHccWbbtwqYCN5hwkVixA@mail.gmail.com>
 <CAA4eK1LefopSMb6XQ7b6hw+GmZw-wDAOWhq+YXM9iC4Y6Mdtjw@mail.gmail.com>
 <CAD21AoCN9Z1D43R5uT84w0HEPBP-gH5Gy5nVcn5Nf3fja47_tQ@mail.gmail.com>
In-Reply-To: 
 <CAD21AoCN9Z1D43R5uT84w0HEPBP-gH5Gy5nVcn5Nf3fja47_tQ@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Thu, 28 Jul 2022 15:23:54 +0530
Message-ID: 
 <CAA4eK1JxVro2YvP2ocw5Th0den3uZipLHkM+8pOCsPkYmWa3cw@mail.gmail.com>
Subject: Re: [BUG] Logical replication failure "ERROR: could not map filenode
 "base/13237/442428" to relation OID" with catalog modifying txns
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>,
 Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
	"Drouvot, Bertrand" <bdrouvot@amazon.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, "Oh,
 Mike" <minsoo@amazon.com>
Content-Type: multipart/mixed; boundary="0000000000009a5a6805e4da8384"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1JxVro2YvP2ocw5Th0den3uZipLHkM%2B8pOCsPkYmWa3cw%40mail.gmail.com>
Precedence: bulk

--0000000000009a5a6805e4da8384
Content-Type: text/plain; charset="UTF-8"

On Tue, Jul 26, 2022 at 1:22 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> Okay, I've attached an updated patch that does the above idea. Could
> you please do the performance tests again to see if the idea can help
> reduce the overhead, Shi yu?
>

While reviewing the patch for HEAD, I have changed a few comments. See
attached, if you agree with these changes then include them in the
next version.

-- 
With Regards,
Amit Kapila.

--0000000000009a5a6805e4da8384
Content-Type: application/octet-stream; name="master_v9_amit.diff.patch"
Content-Disposition: attachment; filename="master_v9_amit.diff.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_l64uyuq70>
X-Attachment-Id: f_l64uyuq70

ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvc25hcGJ1aWxkLmMg
Yi9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3NuYXBidWlsZC5jCmluZGV4IGFiNmJh
ZTNiNmUuLmNhNTZmN2JmZTMgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xv
Z2ljYWwvc25hcGJ1aWxkLmMKKysrIGIvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9z
bmFwYnVpbGQuYwpAQCAtMjQ3LDE1ICsyNDcsMTggQEAgc3RydWN0IFNuYXBCdWlsZAogCSAqIGFu
ZCB3ZXJlIHJ1bm5pbmcgd2hlbiB0aGUgc25hcHNob3Qgd2FzIHNlcmlhbGl6ZWQuCiAJICoKIAkg
KiBXZSBub3JtYWxseSByZWx5IG9uIEhFQVAyX05FV19DSUQgYW5kIFhMT0dfWEFDVF9JTlZBTElE
QVRJT05TIHJlY29yZHMgdG8KLQkgKiBrbm93IGlmIHRoZSB0cmFuc2FjdGlvbiBoYXMgY2hhbmdl
ZCB0aGUgY2F0YWxvZy4gQnV0IGl0IGNvdWxkIGhhcHBlbiB0aGF0Ci0JICogdGhlIGxvZ2ljYWwg
ZGVjb2RpbmcgZGVjb2RlcyBvbmx5IHRoZSBjb21taXQgcmVjb3JkIG9mIHRoZSB0cmFuc2FjdGlv
bi4KLQkgKiBUaGlzIGFycmF5IHN0b3JlcyB0aGUgdHJhbnNhY3Rpb25zIHRoYXQgaGF2ZSBtb2Rp
ZmllZCBjYXRhbG9ncyBhbmQgd2VyZQotCSAqIHJ1bm5pbmcgd2hlbiBzZXJpYWxpemluZyBhIHNu
YXBzaG90LCBhbmQgdGhpcyBhcnJheSBpcyB1c2VkIHRvIGFkZCBzdWNoCi0JICogdHJhbnNhY3Rp
b25zIHRvIHRoZSBzbmFwc2hvdC4KKwkgKiBrbm93IGlmIHRoZSB0cmFuc2FjdGlvbiBoYXMgY2hh
bmdlZCB0aGUgY2F0YWxvZy4gQnV0IGl0IGNvdWxkIGhhcHBlbgorCSAqIHRoYXQgdGhlIGxvZ2lj
YWwgZGVjb2RpbmcgZGVjb2RlcyBvbmx5IHRoZSBjb21taXQgcmVjb3JkIG9mIHRoZQorCSAqIHRy
YW5zYWN0aW9uIGFmdGVyIHJlc3RvcmluZyB0aGUgcHJldmlvdXNseSBzZXJpYWxpemVkIHNuYXBz
aG90IGluIHdoaWNoCisJICogY2FzZSB3ZSB3aWxsIG1pc3MgYWRkaW5nIHRoZSB4aWQgdG8gdGhl
IHNuYXBzaG90IGFuZCBlbmQgdXAgbG9va2luZyBhdAorCSAqIHRoZSBjYXRhbG9ncyB3aXRoIHRo
ZSB3cm9uZyBzbmFwc2hvdC4KIAkgKgotCSAqIFRoaXMgYXJyYXkgaXMgc2V0IG9uY2Ugd2hlbiBy
ZXN0b3JpbmcgdGhlIHNuYXBzaG90LCB3ZSByZW1vdmUgeGlkcyBmcm9tCi0JICogdGhpcyBhcnJh
eSB3aGVuIHRoZXkgYmVjb21lIG9sZCBlbm91Z2ggdG8gbWF0dGVyLCBhbmQgdGhlbiBpdCBldmVu
dHVhbGx5Ci0JICogYmVjb21lcyBlbXB0eS4KKwkgKiBOb3cgdG8gYXZvaWQgdGhlIGFib3ZlIHBy
b2JsZW0sIHdlIHNlcmlhbGl6ZSB0aGUgdHJhbnNhY3Rpb25zIHRoYXQgaGFkCisJICogbW9kaWZp
ZWQgdGhlIGNhdGFsb2dzIGFuZCBhcmUgc3RpbGwgcnVubmluZyBhdCB0aGUgdGltZSBvZiBzbmFw
c2hvdAorCSAqIHNlcmlhbGl6YXRpb24uIFdlIGZpbGwgdGhpcyBhcnJheSB3aGlsZSByZXN0b3Jp
bmcgdGhlIHNuYXBzaG90IGFuZCB0aGVuCisJICogcmVmZXIgaXQgd2hpbGUgZGVjb2RpbmcgY29t
bWl0IHRvIGVuc3VyZSBpZiB0aGUgeGFjdCBoYXMgbW9kaWZpZWQgdGhlCisJICogY2F0YWxvZy4g
V2UgcmVtb3ZlIHhpZHMgZnJvbSB0aGlzIGFycmF5IHdoZW4gdGhleSBiZWNvbWUgb2xkIGVub3Vn
aCB0bworCSAqIG1hdHRlciwgYW5kIHRoZW4gaXQgZXZlbnR1YWxseSBiZWNvbWVzIGVtcHR5Lgog
CSAqLwogCXN0cnVjdAogCXsKQEAgLTkyNCw5ICs5MjcsOSBAQCBTbmFwQnVpbGRBZGRDb21taXR0
ZWRUeG4oU25hcEJ1aWxkICpidWlsZGVyLCBUcmFuc2FjdGlvbklkIHhpZCkKICAqIHRoZSAtPmNv
bW1pdHRlZCBvciAtPmNhdGNoYW5nZSBhcnJheSwgcmVzcGVjdGl2ZWx5LiBUaGUgY29tbWl0dGVk
IHhpZHMgd2lsbAogICogZ2V0IGNoZWNrZWQgdmlhIHRoZSBjbG9nIG1hY2hpbmVyeS4KICAqCi0g
KiBXZSBjYW4gaWRlYWxseSByZW1vdmUgdGhlIHRyYW5zYWN0aW9uCi0gKiBmcm9tIGNhdGNoYW5n
ZSBhcnJheSBvbmNlIGl0IGlzIGZpbmlzaGVkIChjb21taXR0ZWQvYWJvcnRlZCkgYnV0IHRoYXQg
Y291bGQKLSAqIGJlIGNvc3RseSBhcyB3ZSBuZWVkIHRvIG1haW50YWluIHRoZSB4aWRzIG9yZGVy
IGluIHRoZSBhcnJheS4KKyAqIFdlIGNhbiBpZGVhbGx5IHJlbW92ZSB0aGUgdHJhbnNhY3Rpb24g
ZnJvbSBjYXRjaGFuZ2UgYXJyYXkgb25jZSBpdCBpcworICogZmluaXNoZWQgKGNvbW1pdHRlZC9h
Ym9ydGVkKSBidXQgdGhhdCBjb3VsZCBiZSBjb3N0bHkgYXMgd2UgbmVlZCB0byBtYWludGFpbgor
ICogdGhlIHhpZHMgb3JkZXIgaW4gdGhlIGFycmF5LgogICovCiBzdGF0aWMgdm9pZAogU25hcEJ1
aWxkUHVyZ2VPbGRlclR4bihTbmFwQnVpbGQgKmJ1aWxkZXIpCkBAIC0xMTcxLDggKzExNzQsOCBA
QCBTbmFwQnVpbGRYaWRIYXNDYXRhbG9nQ2hhbmdlcyhTbmFwQnVpbGQgKmJ1aWxkZXIsIFRyYW5z
YWN0aW9uSWQgeGlkLAogCQlyZXR1cm4gdHJ1ZTsKIAogCS8qCi0JICogSWYgdGhlIGNvbW1pdCBy
ZWNvcmQgb2YgdGhlIHRyYW5zYWN0aW9uIGRvZXMgbm90IGhhdmUgaW52YWxpZGF0aW9uCi0JICog
bWVzc2FnZXMsIGl0IGRpZCBub3QgY2hhbmdlIGNhdGFsb2dzIGZvciBzdXJlLgorCSAqIFRoZSB0
cmFuc2FjdGlvbnMgdGhhdCBoYXZlIGNoYW5nZWQgY2F0YWxvZ3MgbXVzdCBoYXZlIGludmFsaWRh
dGlvbgorCSAqIGluZm8uCiAJICovCiAJaWYgKCEoeGluZm8gJiBYQUNUX1hJTkZPX0hBU19JTlZB
TFMpKQogCQlyZXR1cm4gZmFsc2U7Cg==
--0000000000009a5a6805e4da8384--