Hi all, Before PG 14, walsender process has to handle invalid message in one XLOG (PG 14 provide a particular XLOG type: XLOG_XACT_INVALIDATIONS). This may bring some problems which has been discussed in previous mail: https://www.postgresql.org/message-id/flat/CAM_vCufO3eeRZ_O04z9reiE%2BB644%2BRgczbAVo9C5%2BoHV9S7%2B-g%40mail.gmail.com#981e65567784e0aefa4474cc3fd840f6
This patch can solve the problem. It has three parts: 1. pgoutput do not do useless invalid cache anymore; 2. Add a relid->relfilenode hash map to invoid hash seq search; 3. test case: It needs two or three minutes to finish. The patch is based on the HEAD of branch REL_13_STABLE. It also works for PG 10~12. Thanks. Bowenshi
0001-Optimize-invalidating-cache-in-pgoutput-and-relfilen.patch
Description: Binary data
