| 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
| 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 |