logical replication, initial sync on 8 tables running for 2 days and sub table size is 4x pub table size

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: logical replication, initial sync on 8 tables running for 2 days and sub table size is 4x pub table size
Date: 2026-02-17 21:06:06
Message-ID: 654e7029-a8cf-4dcf-85e9-b360f08308ba@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Ed Sabol 2026-02-19 01:47:27 Duplicate key value violates unique constraint "pg_type_typname_nsp_index" error
Previous Message Laurenz Albe 2026-02-16 14:42:11 Re: RHEL upgrade