public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sbob <[email protected]>
To: [email protected]
Subject: logical replication, initial sync on 8 tables running for 2 days and sub table size is 4x pub table size
Date: Tue, 17 Feb 2026 14:06:06 -0700
Message-ID: <[email protected]> (raw)
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: logical replication, initial sync on 8 tables running for 2 days and sub table size is 4x pub table size
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox