Re: My Pgbackrest Backups Take Up Too Much Space

On Tue, Feb 18, 2025 at 7:17 AM Abdullah Ergin <abdullaherginwork(at)gmail(dot)com>
wrote:

> Hi,
> I have a 9.3 TB database. And when I take a full backup, the space it
> occupies in the repo is 8.7 TB. This compression is not enough for me. It
> needs to be compressed more, I did not enter any parameters on my backup
> server for compression, so it compresses with default parameters (gz).
> Normally gz compresses well, why is there so little compression?
>

Is your data very compressible?
Are you sure the backups are being compressed?

> Also my archive files, the two days archive file of my stanza is now
> 744GB. I understand that my old archive files are not deleted after my incr
> backup. Wouldn't my old archive files be redundant after my incremental
> backups, wouldn't it be better to delete them?
>

Not if you ever need to restore to a PIT somewhere in the middle of the day.

And there's always open transactions which might be open when you start
pgbackrest.

> What is the parameter to ensure deletion?
>

There isn't one, since it's a bad idea.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!