public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Ertan Küçükoglu <ertan.kucukoglu@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Large backup size of pg_dump
Date: Wed, 20 May 2026 10:17:57 +0300
Message-ID: <CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com> (raw)

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

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: pgsql-general@postgresql.org
  Cc: ertan.kucukoglu@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Large backup size of pg_dump
  In-Reply-To: <CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com>

* 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