Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher
Önder Kalacı <onderkalaci@gmail.com>
From: Önder Kalacı <onderkalaci@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: "shiy.fnst@fujitsu.com" <shiy.fnst@fujitsu.com>, "wangw.fnst@fujitsu.com" <wangw.fnst@fujitsu.com>,
Amit Kapila <amit.kapila16@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-12-12T13:28:23Z
Lists: pgsql-hackers
Attachments
- v22_0001_use_index_on_subs_when_pub_rep_ident_full.patch (application/octet-stream) patch v22
Hi, Thanks for the heads-up. > Needs another rebase, I think: > > https://cirrus-ci.com/task/5592444637544448 > > [05:44:22.102] FAILED: > src/backend/postgres_lib.a.p/replication_logical_worker.c.o > [05:44:22.102] ccache cc -Isrc/backend/postgres_lib.a.p -Isrc/include > -I../src/include -Isrc/include/storage -Isrc/include/utils > -Isrc/include/catalog -Isrc/include/nodes -fdiagnostics-color=always -pipe > -D_FILE_OFFSET_BITS=64 -Wall -Winvalid-pch -g -fno-strict-aliasing -fwrapv > -fexcess-precision=standard -D_GNU_SOURCE -Wmissing-prototypes > -Wpointer-arith -Werror=vla -Wendif-labels -Wmissing-format-attribute > -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local > -Wformat-security -Wdeclaration-after-statement -Wno-format-truncation > -Wno-stringop-truncation -fPIC -pthread -DBUILDING_DLL -MD -MQ > src/backend/postgres_lib.a.p/replication_logical_worker.c.o -MF > src/backend/postgres_lib.a.p/replication_logical_worker.c.o.d -o > src/backend/postgres_lib.a.p/replication_logical_worker.c.o -c > ../src/backend/replication/logical/worker.c > [05:44:22.102] ../src/backend/replication/logical/worker.c: In function > ‘get_usable_indexoid’: > [05:44:22.102] ../src/backend/replication/logical/worker.c:2101:36: error: > ‘ResultRelInfo’ has no member named ‘ri_RootToPartitionMap’ > [05:44:22.102] 2101 | TupleConversionMap *map = > relinfo->ri_RootToPartitionMap; > [05:44:22.102] | ^~ > > Yes, it seems the commit (fb958b5da86da69651f6fb9f540c2cfb1346cdc5) broke the build and commit(a61b1f74823c9c4f79c95226a461f1e7a367764b) broke the tests. But the fixes were trivial. All tests pass again. Attached v22. Onder KALACI
Commits
-
Add the testcases for 89e46da5e5.
- 805b821e77a3 16.0 landed
-
Allow the use of indexes other than PK and REPLICA IDENTITY on the subscriber.
- 89e46da5e511 16.0 landed
-
Rework query relation permission checking
- a61b1f74823c 16.0 cited
-
Generalize ri_RootToPartitionMap to use for non-partition children
- fb958b5da86d 16.0 cited
-
Add wait_for_subscription_sync for TAP tests.
- 0c20dd33db16 16.0 cited
-
Logical replication
- 665d1fad99e7 10.0 cited