Initial COPY of Logical Replication is too slow - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Initial COPY of Logical Replication is too slow
Date
Msg-id CAB-JLwbBFNuASyEnZWP0Tck9uNkthBZqi6WoXNevUT6+mV8XmA@mail.gmail.com
Whole thread Raw
Responses Re: Initial COPY of Logical Replication is too slow
List pgsql-hackers
Subscriber needs to ask publisher about tables and fields to COPY and it uses pg_get_publication_tables for that, and it is too slow when the number of tables is high because on every table it's subscribed it has to run this select. 
We can get the same result with a join on pg_publication_rel.

regards
Marcos
Attachment

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: increased duration of stats_ext tests with -DCLOBBER_CACHE_ALWAYS
Next
From: "cca5507"
Date:
Subject: Fix incorrect comments in tuplesort.c