Feedback-ID: i374947ac:Fastmail
Message-ID: <654e7029-a8cf-4dcf-85e9-b360f08308ba@quadratum-braccas.com>
Date: Tue, 17 Feb 2026 14:06:06 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-admin@lists.postgresql.org
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: logical replication, initial sync on 8 tables running for 2 days and
 sub table size is 4x pub table size
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/654e7029-a8cf-4dcf-85e9-b360f08308ba%40quadratum-braccas.com>
Precedence: bulk

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