| From: | Ertan Küçükoglu <ertan(dot)kucukoglu(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Large backup size of pg_dump |
| Date: | 2026-05-20 07:17:57 |
| Message-ID: | CAH2i4yfdgWf5N+ofPineFW2a97cFT0F9b255HmcEDJ06dc=huA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Priancka Chatz | 2026-05-20 11:23:09 | Re: Large backup size of pg_dump |
| Previous Message | Ron Johnson | 2026-05-19 20:18:04 | Re: scaling up from t1n to 60 million records |