All;
I have setup logical replication on 2 PostgreSQL 14 servers. The
source/PUBLISHER table is 145GB and target/SUBSCRIBER table is 626GB and
growing, initial sync still not complete.
The subscriber table is 4x the size of the publisher table based on a
"select pg_total_relation_size call on both the publisher and subscriber,
the subscriber of course shows 0 rows from a select count(*) since the
initial sync is still not finished.
tablename | pub_size | sub_size | diff_size
-------------------+--------------+--------------+---------------
myschema.srctab_a | 156178972672 | 671712460800 | -515533488128
myschema.srctab_b | 165219573760 | 676107206656 | -510887632896
myschema.srctab_c | 145452384256 | 657165025280 | -511712641024
myschema.srctab_d | 4700569600 | 855325974528 | -850625404928
myschema.srctab_e | 156178972672 | 671713402880 | -515534430208
myschema.srctab_f | 165219573760 | 676108140544 | -510888566784
myschema.srctab_g | 145452384256 | 657165836288 | -511713452032
myschema.srctab_h | 4700569600 | 855325974528 | -850625404928
Both publisher and subscriber are PostgreSQL v14
Anyone have any thoughts on why the table sizes are so different?
Thanks in advance
