update:
i dropped all the indexes on the dest db tables, but the primary key
and unique constraints from base tables in logical replication to
ensure replica identity.
and retriggered the logical replication from scratch.
it completed in 4 hours. (which otherwise ran for 4 days)
so i guess it was
Hey Guys,
tl;dr, but incase i missed something, i can follow up on this with more details.
I have a setup where i try to upgrade a cluster from pg10 to pg11 via
logical replication with minimum downtime.
its a database that is 500GB with 1 table having 350GB of data (+
bloat) and 100GB of indexe
