MIME-Version: 1.0
From: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Date: Wed, 20 May 2026 10:17:57 +0300
Message-ID: 
 <CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com>
Subject: Large backup size of pg_dump
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001c3c5906523a990c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAH2i4yfdgWf5N%2BofPineFW2a97cFT0F9b255HmcEDJ06dc%3DhuA%40mail.gmail.com>
Precedence: bulk

--0000000000001c3c5906523a990c
Content-Type: text/plain; charset="UTF-8"

Hello,

I am using PostgreSQL 18.4 x64 on Windows Server 2022. There is a very
small single database in the cluster.

There are hourly pg_dump backups scheduled and database backup size is
around 10GB.

command line is like below
pg_dump.exe -p 5432 -U dbuser --exclude-table=app -F p -b -c -f "hourly.bak"

When I check the cluster directory size it is 4.1 GB.

Database has one BLOB saved in a single record and it is 16MB in size and
that is in the "app" table which is excluded from the backup file.

I didn't understand about 2.5 times bigger backup sizes than the total
cluster size. I do not know what to check either. Is there a way for me to
make the hourly backup size smaller?

Thanks & Regards,
Ertan

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

<div dir=3D"ltr">Hello,<div><br></div><div>I am using PostgreSQL 18.4 x64 o=
n Windows=C2=A0Server 2022. There is a very small single database in the cl=
uster.</div><div><br></div><div>There are hourly pg_dump backups scheduled =
and database backup size is around 10GB.</div><div><br></div><div>command l=
ine is like below</div><div>pg_dump.exe -p 5432 -U dbuser --exclude-table=
=3Dapp -F p -b -c -f &quot;hourly.bak&quot;</div><div><br></div><div>When I=
 check the cluster directory size it is 4.1 GB.</div><div><br></div><div>Da=
tabase has one BLOB saved in a single record and it is 16MB in size and tha=
t is in the &quot;app&quot; table which is excluded from the backup file.</=
div><div><br></div><div>I didn&#39;t understand about 2.5 times bigger back=
up sizes than the total cluster size. I do not know what to check either. I=
s there a way for me to make the hourly backup size smaller?</div><div><br>=
</div><div>Thanks &amp;=C2=A0Regards,</div><div>Ertan</div></div>

--0000000000001c3c5906523a990c--