MIME-Version: 1.0
From: James Pang <jamespang886@gmail.com>
Date: Sun, 19 Apr 2026 09:28:31 +0800
Message-ID: 
 <CAHgTRff=eH1GwVb=ENMzX6hBEajdTccCQbeVRkj4OtYLm69a9g@mail.gmail.com>
Subject: table bloat very fast and free space can not be reused
To: pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002d41cd064fc61a56"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHgTRff%3DeH1GwVb%3DENMzX6hBEajdTccCQbeVRkj4OtYLm69a9g%40mail.gmail.com>
Precedence: bulk

--0000000000002d41cd064fc61a56
Content-Type: text/plain; charset="UTF-8"

experts:
     source database v14 ,  pglogical extension 2.4.5 replication to new
17, source table very frequent UPDATEs /DELETES /INSERTS and has two text
and jsonb. in source database, application update/delete/insert through
SQL, table size did not increased quickly. but in target pg v17 , by
pglogical apply, we found table increased very quickly , table size got
doubled in days.
    Vacuum analyze did not help , only vacuum full can help. pgstattuple
show most of space are free space , that much more than source.  it looks
like these replicate DML always asking new pages instead of reuse existing
freespace.

Thanks,

James

--0000000000002d41cd064fc61a56
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">experts:<div>=C2=A0 =C2=A0 =C2=A0source database v14 ,=C2=
=A0 pglogical extension 2.4.5 replication to new 17, source table very freq=
uent UPDATEs /DELETES /INSERTS and has two text and jsonb. in source databa=
se, application update/delete/insert through SQL, table size did not increa=
sed quickly. but in target pg v17 , by pglogical apply, we found table incr=
eased very quickly , table size got doubled in days.=C2=A0=C2=A0</div><div>=
=C2=A0 =C2=A0 Vacuum analyze did not help , only vacuum full can help. pgst=
attuple show most of space are free space , that much more than source.=C2=
=A0 it looks like these replicate DML always asking new pages instead of re=
use existing freespace.=C2=A0</div><div>=C2=A0 =C2=A0=C2=A0</div><div>Thank=
s,</div><div><br></div><div>James</div></div>

--0000000000002d41cd064fc61a56--