| From: | KK CHN <kkchn(dot)in(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Pgbackrest info output interpretation |
| Date: | 2025-11-14 08:32:38 |
| Message-ID: | CAKgGyB-4HmSMCg8L1_HCvK6jF=-bJtxn9v4oCH-jY0EdzKH-Lw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am having confusion trying to understand the database size, backupsize
and repo backup size..
In my DB server I have du output as follows.
/data/edb/as16
[root(at)db1 as16]# du -h -d 1
5.3G ./data
25G ./tablespace
30G .
[root(at)db1 as16]#
On my Repo Server pgbackest info says ....
full backup: 20251114-121504F
timestamp start/stop: 2025-11-14 12:15:04+05:30 / 2025-11-14
12:20:58+05:30
wal start/stop: 000000010000000500000024 /
000000010000000500000024
database size: 3GB, database backup size: 3GB
repo1: backup size: 431.0MB
Could someone shed some light on 431 MB and database size:3GB, database
backup size : 3GB compared to the DB cluster on disk usage output ?
How to correlate the pgbackrest ( info) database size, database backup size
and repo1 backup size and actual du output on DB cluster.
Note: I am using zst compression on pgbackrest
Regards,
Krishane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-11-14 13:42:46 | Re: Pgbackrest info output interpretation |
| Previous Message | Laurenz Albe | 2025-11-13 22:10:18 | Re: Question about MVCC caveats |