|
Hi All, When I have only one table (2.5GB) in logical replication publication it takes 8 minutes to sync to the subscriber when I created a copy of the table and added it to the publication
it took 28 minutes. When I sync three IDENTICAL tables of the same size it take 46 minutes! I expected the tables to be synched in parallel or at least one after the other, but it turned out the time increase is much larger than just to sync additional table of the same
size. Two tables should be 8*2=16 minutes and not 28 and three tables should be 8*3=24 minutes and not 46. The table has one pk int column and one binary column file_content of type bytea. What might be the reason for this behavior? Can I improve the time it takes to sync several tables so it will be no more than the (time to sync one table) * (number of tables) Doing it for two tables took 28 minutes 2021-12-27 10:32:13.740 UTC [4430] LOG: logical replication apply worker for subscription "sub_gwn1" has started 2021-12-27 10:32:13.815 UTC [4431] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p1" has started 2021-12-27 10:32:13.827 UTC [4432] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p" has started 2021-12-27 10:57:57.542 UTC [4432] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p" has finished 2021-12-27 11:00:03.806 UTC [4431] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p1" has finished Doing it for three tables took 46 minutes 2021-12-27 11:49:11.931 UTC [4739] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p2" has started 2021-12-27 11:49:11.948 UTC [4740] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p1" has started 2021-12-27 12:23:44.673 UTC [4740] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p1" has finished 2021-12-27 12:23:44.783 UTC [4845] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p" has started 2021-12-27 12:28:53.320 UTC [4739] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p2" has finished 2021-12-27 12:35:49.156 UTC [4845] LOG: logical replication table synchronization worker for subscription "sub_gwn1", table "p" has finished Thanks! |
